conditional formula

J

Janet58

I am trying to create a formula with the condition based an a Letter is this
possible
Skilled Unskilled Day 1 Day 30 Day 60
Unskilled Date

4-Dec-08 2-Jan-09 1-Feb-09
If U I want to I need to calculate a date if S I would like it to stay blank.
 
S

Satti Charvak

Try using the formula:

=IF(MID(E16,FIND("[",E16)+1,1)="S","No date","Calculate Date")

Don't forget to place your code instead of "No Date" and "Calculate Date"
 

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

Top