IF FORMULAS- using AND , OR

Question

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%

hansvogelaar · Answer

cmcc182002&nbsp;
&nbsp;
You cannot produce results in two cells in one formula.
Can you tell us where the results should go?

cmcc182002 · Answer

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

hansvogelaar · Answer

cmcc182002&nbsp;
In which cells do you want a formula? Please provide specific information.

cmcc182002 · Answer

D24 and D28

hansvogelaar · Answer

cmcc182002&nbsp;
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&gt;E13,D4*15%,0)
And in D29: =IF(E9&gt;E14,E4*15%,0)

Forum Discussion

IF FORMULAS- using AND , OR

5 Replies

Resources