Excel Calculation Help

Gadgetman496 · 01-03-2023 12:14PM #1

I have the following calculation in an Excel 2007 worksheet and I need to tweak it slightly if anyone can help?

=IF(SUM(A18)>0,SUM(A18*E18),"")

The above Calc multiplies cell A18 by Cell E18 and displays the result in cell F18 but only if cell A18 has a value greater than 0 and it works fine, however, I want to change it slightly to stop it placing a zero in cell F18 once a value is put into cell A18

I want the calc above to work only if the value in both A18 and E18 is greater than zero.

ohnonotgmail · 01-03-2023 12:19PM

=IF(AND(SUM(A18)>0,SUM(E18)>0),SUM(A18*E18),"")

though I would question why you need the sum if it only looks at 1 cell. this does the same thing without the sum

=IF(AND(A18>0,E18>0),SUM(A18*E18),"")

Gadgetman496 · 01-03-2023 12:29PM

https://www.boards.ie/discussion/comment/120301075#Comment_120301075

Thank you so much ohnonotgmail, that works exactly as I wanted it to, really appreciate the help and speedy reply.

To answer your question, I have no idea why the SUM was there if not needed, I have very little experience with this stuff along with being an old man, my maths are letting me down too I guess :)

The SUM is removed as per your second example and all working fine.

Thanks again.

ohnonotgmail · 01-03-2023 12:31PM

actually you dont need the other sum either. this is all you need.

=IF(AND(A18>0,E18>0),A18*E18,"")

Gadgetman496 · 01-03-2023 12:34PM

https://www.boards.ie/discussion/comment/120301122#Comment_120301122

I love people who simplify things like that, cheers :)

Excel Calculation Help

Comments