IF FORMULAS- using AND , OR

Copper Contributor
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%
5 Replies

@cmcc182002 

 

You cannot produce results in two cells in one formula.

Can you tell us where the results should go?

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

@cmcc182002 

In which cells do you want a formula? Please provide specific information.

D24 and D28

@cmcc182002 

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)