Round with IF's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this:
=IF(D24="","",ROUND(IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24)),2))
 
try:

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