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.
=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.