Formula Help

Jon Brown

I have the following formula in a cell

=([Actual Case Rate Achieved]57 / [Expected Hourly Case Rate]57 * 1)

This data in the cells "Actual Case Rate Achieved" & "Expected Hourly Case Rate" are not always filled in at the same time, so when information is missing I am gettignthe error "#invalidvalue"

I would like my formula to return "0.0" when the information is not in the cells and the "#invalidvalue" is returned.

Help is much appreciated.

mclarke

You could possibly add an 'if' clause to your formula. .. and or hide the 'calculated' column and then do an 'If' statement in a new column to where if cellx="#invaidvalue, '0.0'

Shaine Greenwood

Hello,

Try adding an IFERROR statement to your formula: https://help.smartsheet.com/function/iferror