Formula IF statement


#1

Hi everyone,

Very new to formulas and writing ‘if’ statements. I’m trying to see if it’s possible to write a formula for what I’m trying to do.

I have a very basic hourly multiplication formula where I multiply hours spent by an amount. Problem is, I have a lot of records and a few months back I was charging at a different rate for one of my employers. I’m hoping to write an if statement that basically says, if the date was before this time and for this client then multiply by this number, otherwise use the current number.

The first part I can do easily enough:

IF({Employer}=“x”,{Hours Spent}*y,{Hours Spent}*z)

I’m just not sure if how to do the filter by a before date, if that’s even possible.

Any help would be greatly appreciated!


#2

Hi Taylor,

You’re looking for nested if statements. In this mockup, I have hard set the rate for company ABC to be 10 before 7/1, 15 after 7/1… and all other employers at 20. Obviously will need to modify to fit your needs, but hope this helps get you started.

IF(Employer="ABC",IF(IS_BEFORE({Date},"7/1/2018"),Hours*10,Hours*15),Hours*20)