How do I insert OR in imbedded formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
Well, You embed it.... into a formula.

....Could you be a little more specific??!
 
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.
 
Ahh, good deal, use this:

=IF(OR(K3="Living with one parent",K3="Living with two parents")," ",C3+150)

Does that help?
 
You must log in or register to reply here.

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

Similar Threads

Export an imbeded Excel file from Word 3
Combo Box Imbedded in Cell? 1
Why do Excel worksheets imbedded in a Word document sometimes corr 1
imbedded if statements 2
Imbedded Macros 3
view imbedded image 8
Stripping out imbedded spaces in a cell/row 8
Hiding/Unhiding Rows Automatically 1

Back
Top