Help with Formula

[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

 

[Pete_UK]

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

 

[Yitzhack]

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

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_UK]

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

Pete

 

[Yitzhack]

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

 

[Pete_UK]

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 -