Round with IF's

[Klee]

I figured out a formula (below) but then realized that I needed to round the
numbers to two decimals so I tried to add Round into it (which I've never
used before). It seems to work except that now the cells that do not have a
number in them are showing a #Value error. Can someone please tell me what I
am missing? Here's what I have

=ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2)

Thanks in advance. I'm very new to Excell and I'm really enjoying learning
it but I think I might have given up a long time ago without this website.

 

[Rodrigo Ferreira]

Try this:
=IF(D24="","",ROUND(IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24)),2))

 

[Toppers]

try:

=IF(D24="","",IF(E24="",ROUND(D24-F24,2),IF(E24=0,ROUND(D24-F24,2),ROUND(D24*E24-F24,2))))

 

[Klee]

Thank you, this is perfect!

Try this:
=IF(D24="","",ROUND(IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24)),2))