Forum Discussion
IF FORMULAS- using AND , OR
I am needing help! What I am doing wrong. I am trying to calculate this formula and if both values are more or than equal to I must multiply them both by 15%
I have added another image to show thanks. I am wanting the true answer to be either 15%*D4 or 15% *E4 for example and if not return 0
In which cells do you want a formula? Please provide specific information.
- D24 and D28
It's very difficult to understand what you actually want.
Perhaps you can modify the following formulas to suit your purpose.
In D24: =IF(E4>E13,D4*15%,0)
And in D29: =IF(E9>E14,E4*15%,0)