PDA

View Full Version : Formula with no error message?



apharrington
12-06-2006, 02:54 PM
How would I write this formula to round without it displaying an error message if the cell is left blank?

=IF(ISERROR(F17*H17),"",IF(F17=-1,H17,F17*H17))

I tried:

=ROUND(IF(ISERROR(F17*H17),"",IF(F17=-1,H17,F17*H17)),2)

it returns #VALUE! if left blank.

Bob Phillips
12-06-2006, 03:02 PM
=IF(ISERROR(F17*H17),"",ROUND(IF(F17=-1,H17,F17*H17)),2)

mdmackillop
12-06-2006, 03:05 PM
I don't get an error with a blank cell, but I do if I enter text. Anyway, try

=IF(ISERROR(F17*H17),"",IF(F17=-1,ROUND(H17,2),ROUND(F17*H17,2)))

apharrington
12-06-2006, 03:36 PM
THANK YOU! THANK YOU!

I love this site already!!! :joy: