Formula

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I need help with the following formula:

If G1 is PT then blank otherwise N1+83

G1 is a text field:
PT for Part Time
FT for Full Time
MGR for Manager

N1 is a date field.
 
Donna said:
I need help with the following formula:

If G1 is PT then blank otherwise N1+83

G1 is a text field:
PT for Part Time
FT for Full Time
MGR for Manager

N1 is a date field.
Click to expand...


=If(G1="PT";"";N1+83)

PS: probably in your language you have to use "," instead of ";"

Sergio
 
Back
Top