|
Help with Formula
Hello all €“
Please help!!! I cant 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 -- Regards YM |
Help with Formula
Try this in H9:
=IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),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 On Sep 3, 1:51*am, Yitzhack wrote: 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 -- Regards YM |
Help with Formula
Pete,
Basically, will add 30 or 180 days to lets say todays 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" wrote: Try this in H9: =IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),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 On Sep 3, 1:51 am, Yitzhack wrote: Hello all €“ Please help!!! I cant 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 -- Regards YM |
Help with Formula
Yes, but if F9 is empty or contains "xyz" or "wfm6" then what do you
want to show in the cell? Pete On Sep 3, 2:19*am, Yitzhack wrote: 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" wrote: Try this in H9: =IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),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 On Sep 3, 1:51 am, Yitzhack wrote: 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 -- Regards YM- Hide quoted text - - Show quoted text - |
Help with Formula
Actually the formula that you provided works for what I needed.
Thanks so much Pete -- Regards YM "Pete_UK" wrote: Yes, but if F9 is empty or contains "xyz" or "wfm6" then what do you want to show in the cell? Pete On Sep 3, 2:19 am, Yitzhack wrote: Pete, Basically, will add 30 or 180 days to lets say todays 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" wrote: Try this in H9: =IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),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 On Sep 3, 1:51 am, Yitzhack wrote: Hello all €“ Please help!!! I cant 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 -- Regards YM- Hide quoted text - - Show quoted text - |
Help with Formula
You're welcome - thanks for feeding back.
Pete On Sep 4, 2:06*am, Yitzhack wrote: Actually the formula that you provided works for what I needed. Thanks so much Pete -- Regards YM "Pete_UK" wrote: Yes, but if F9 is empty or contains "xyz" or "wfm6" then what do you want to show in the cell? Pete On Sep 3, 2:19 am, Yitzhack wrote: 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" wrote: Try this in H9: =IF(F9="WFM",G9+30,IF(OR(F9="WFM1",F9="WFM2",F9="W FM3"),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 On Sep 3, 1:51 am, Yitzhack wrote: 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 -- Regards YM- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com