Formula Help

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.

Find more posts tagged with

Manufacturing

Comments

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