Formula

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.
 
A

AquaStar SA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with MS Word paragraph and character styles: format getting messed up 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Formula than understands midnight? 26
Conditional Formatting Formula 3
Multiple IF's Using Formulas from Other Cells 7
If Then Or Statement 3
formula to add year to date figures 3
Excel IF, AND, OR ?'s 6

Top