Forum Discussion
IF OR AND Functions
I have set up a drop down menu with four values (revenue, expenses, capital infusion, and return of capital). I also have a column where amounts will be entered. I want to ensure that only positi...
=IF(AND(H8>0,OR(B8="Revenues",B8="Capital Infusion")),"ok","Error")Is this what you are looking for?
Thanks very much. That works. Is there a way to add to it also that if B8 is "Expense" or "Return of Capital" and H8 is <0 that that is ok?
Cell B8 has four options, two need to have cell H8 positive to be ok and the other two need to have cell H8 negative in order to be correct.
Cell B8 has four options, two need to have cell H8 positive to be ok and the other two need to have cell H8 negative in order to be correct.