Help with Formula

  • Thread starter Thread starter Yitzhack
  • Start date Start date
Y

Yitzhack

Hello all –
Please help!!! I can’t make this work. I need a formula in cell H9 where if
cell F9=WFM add 30 days to date in G9, if WFM1, WFM2, or WFM3 in cell F9 add
180 days to date in G9.
Thanks in advance
 
Try this in H9:

=IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="WFM3"),G9+180,"not
defined"))

You do not say what you want to return if those conditions are not
met. You might like to change "not defined" to G9, or 0 ...

Format the cell as a date.

Hope this helps.

Pete
 
Pete,
Basically, will add 30 or 180 days to let’s say today’s date, so if is wfm
in cell f9 and in cell g9 is 9/2/2008, cell g9 will show 10/2/2008.


Thanks

--
Regards
YM



Pete_UK said:
Try this in H9:

=IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="WFM3"),G9+180,"not
defined"))

You do not say what you want to return if those conditions are not
met. You might like to change "not defined" to G9, or 0 ...

Format the cell as a date.

Hope this helps.

Pete
Click to expand...
 
Yes, but if F9 is empty or contains "xyz" or "wfm6" then what do you
want to show in the cell?

Pete
 
Actually the formula that you provided works for what I needed.
Thanks so much Pete
 
You're welcome - thanks for feeding back.

Pete

Actually the formula that you provided works for what I needed.
Thanks so much Pete

--
Regards
YM





- Show quoted text -
Click to expand...
 
Back
Top