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()
)

    ?

amitchandak's avatar
amitchandak
Super User
6 years ago

HenryJS 

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