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

Georgie

Hi @Samuel Dowdy Jr.,

It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.

If that’s correct, try this:

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

Does that work for you?

Georgie

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.

Samuel Dowdy Jr.

Yes, I need it to read if true. Can you help me write it? Basically if the worked performed is 0 then I need it to calculate the other formula. But if its greater than 0 then it need to calculate the first formula

Georgie

Hi @Samuel Dowdy Jr.,

It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.

If that’s correct, try this:

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

Does that work for you?

Georgie

Itai Perez

Hi @Samuel Dowdy Jr.

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

I think this is what you are looking for. Like @kowal said, you were missing an IF false statement.

Let me know if it works.

kowal

hi @Samuel Dowdy Jr. sorry for late response but as I was not tagged I did not get the notification.

Is your problem already solved?

Samuel Dowdy Jr.

@Georgie answered my question. Thank you so much everyone.