How do I insert OR in imbedded formulas?
How do I insert OR in imbedded formulas?
|
Well, You embed it.... into a formula.
....Could you be a little more specific??! -- Regards, Dave "bfd" wrote: How do I insert OR in imbedded formulas? |
Here is the formula I am trying to enter:
=IF(K3=Living with one Parent, Living with two Parents," ",C3+150) If Living with one parent or Living with two parents is in a certain cell, then I want the answer to be a blank cell. If the reference cell says something other than ...Parent...then I want the cell to reference another cell to calculate 150 days after that date. "David Billigmeier" wrote: Well, You embed it.... into a formula. ...Could you be a little more specific??! -- Regards, Dave "bfd" wrote: How do I insert OR in imbedded formulas? |
Ahh, good deal, use this:
=IF(OR(K3="Living with one parent",K3="Living with two parents")," ",C3+150) Does that help? -- Regards, Dave "bfd" wrote: Here is the formula I am trying to enter: =IF(K3=Living with one Parent, Living with two Parents," ",C3+150) If Living with one parent or Living with two parents is in a certain cell, then I want the answer to be a blank cell. If the reference cell says something other than ...Parent...then I want the cell to reference another cell to calculate 150 days after that date. "David Billigmeier" wrote: Well, You embed it.... into a formula. ...Could you be a little more specific??! -- Regards, Dave "bfd" wrote: How do I insert OR in imbedded formulas? |
All times are GMT +1. The time now is 01:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com