Need help for almost working custom calculator

btccalc

New member
Joined
May 9, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Hi!
I am trying to make my own calculator with excel. It almost working,
but I have little errors and I am unsuccefull to fix it, hope you can help me.
Please watch the atached sheet:

If I enter a number <=40% of A5 in C4; I want F12 (or result of G9+G10+F11+F12) to be showed in D3 instead of 0.00
If I enter a number <=40% of A5 in C4; I want anything <= -1 in E10 to be blank.
If I enter a number >=62.5% of A5 in C4; I want anything <= -1 in E11 to be blank.

Thanks in advance.
 

Attachments

  • btccalc.xlsx
    12.1 KB · Views: 14
Back
Top