Forum Discussion

Brian Landreth's avatar
Brian Landreth
Copper Contributor
Jan 30, 2018

Looking for formula

Hi,

 

I'm looking for a statement that will provide me the following information:

 

If B9=selection "a" or "b" or "C" and b11>"", "OK TO SAVE"

or

If B9="D" and B20>"","OK TO SAVE"

otherwise

"NOT READY TO SAVE"

 

Ultimately, I want the cell to read "NOT READY TO SAVE" until one of the arguments is true based on the selection in B9.

 

Hope this makes sense.


I appreciate the feedback.

Formulas & Functions
Need Help

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jan 30, 2018

    Hi Brian,

     

    You practically wrote the formula, just add some formalities

    If B9=selection "a" or "b" or "C" and b11>"", "OK TO SAVE"
or
If B9="D" and B20>"","OK TO SAVE"
otherwise
"NOT READY TO SAVE"

==>

=IF(
   OR(
      AND(OR(B9="a",B9="b",B9="C"),b11>""),
      AND(B9="D",B20>"")
   ), "OK TO SAVE",
   "NOT READY TO SAVE"
)

    Another story are variants and what do you mean under expressions like b11>""

     

Resources