Apr 30 2021 06:33 AM - edited Apr 30 2021 06:45 AM
Apr 30 2021 06:41 AM
You cannot produce results in two cells in one formula.
Can you tell us where the results should go?
Apr 30 2021 06:46 AM - edited Apr 30 2021 06:48 AM
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
Apr 30 2021 06:58 AM
In which cells do you want a formula? Please provide specific information.
Apr 30 2021 07:09 AM
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)