Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

New Column

Hi all,   How do I create a column for the below which states: IF [HourlyOrShiftRate] = per day & Rate1PayRate >= 180 || IF [HourlyOrShiftRate] = per hour & Rate1PayRate >= 18 THEN Yes Else Bl...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • az38's avatar
    az38
    6 years ago

    Hi HenryJS 

    = IF( 
OR([HourlyOrShiftRate] = "per day" && [Rate1PayRate] >= 180,
[HourlyOrShiftRate] = "per hour" && [Rate1PayRate] >= 18),
"Yes",
BLANK()
)

    ?

az38's avatar
az38
Community Champion
6 years ago

Hi HenryJS 

= IF( 
OR([HourlyOrShiftRate] = "per day" && [Rate1PayRate] >= 180,
[HourlyOrShiftRate] = "per hour" && [Rate1PayRate] >= 18),
"Yes",
BLANK()
)

?