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%
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
In which cells do you want a formula? Please provide specific information.
- D24 and D28
