Need an If/Then formula for this

JPFisher

IF "Staff or Freelance" column is "Freelance" then I want to multiply In Rate * Planned Hours and have the result show in the "Freelance Cost" column. if it's "Staff" there should 0 value in the "Freelance Cost"

Thanks

Itai Perez

Hey @JPFisher,

Have you tried an IF formula in the Freelance cost column?

It will be like this: =IF([Staff or Freelance]@row = "Staff", 0, [In Rate]@row * [Planned Hours]@row)

I hope I understood correctly.

Let me know if it works for you!

Itai Perez

Hey @JPFisher,

Have you tried an IF formula in the Freelance cost column?

It will be like this: =IF([Staff or Freelance]@row = "Staff", 0, [In Rate]@row * [Planned Hours]@row)

I hope I understood correctly.

Let me know if it works for you!

JPFisher

Thanks - I just couldn't get it and that did the trick!