If Formula

Samuel Dowdy Jr.

=IF([Work Performed Total]@row / [Employee Count]@row * 12 = 0, [Revenue Projection]@row / [Employee Count]@row * 12)

Why is it if the work performed cell is greater than 0 then the answer is blank? I want it to use revenue projection as the normal answer until work performed numbers start getting entered

Jennifer Kurtz

Good morning!

It looks like your If statement is looking for a value of 0

[Work Performed Total]@row / [Employee Count]@row * 12 = 0

and if that's true it will return the calculation

[Revenue Projection]@row / [Employee Count]@row * 12

Perhaps you intended your condition statement to read >0?

kowal

hi @Samuel Dowdy Jr.

the proper structure of the if function is:

if (logical_expression, value_if_true, value_if_false)

I can see you formula you have only one comma so it means that if the condition is false it will be blank.

Hope this helps.