IF Calculation Help.

[biggles1212]

I have a field named "time_status" and want this to change what it displays based on another field "status".

 

I want "time_status" to equal 'delayed' if "status" equals delayed.

I want "time_status" to equal 'departed' if "status" equals departed.

The last IF would be if "status" is empty I want "time_status" to equal another field named "time".

 

This is my first IF calculation and have read some online examples but they don't seem to be working.

 

Could someone guide me through this?

Thanks,

Adam

[comment]

I want "time_status" to equal 'delayed' if "status" equals delayed.

I want "time_status" to equal 'departed' if "status" equals departed.

The last IF would be if "status" is empty I want "time_status" to equal another field named "time".

 

I believe this could be consolidated into: If status is empty, then show time; otherwise show status. That is, unless you have other case/s to consider, for example when status is not empty, but does not equal "delayed" or "departed".