Mar 07 2022 12:28 PM
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 positive values can be entered for revenue and capital infusion and only negative values can be entered for expenses and return of capital.
Is there a formula that can do that?
Or I was attempting to build a IF/OR/AND formula for a check column, such that IF cell B8 was either "Revenues" OR "Capital Infusion" AND cell H8 was >0, then "ok", otherwise "Error".
I cannot figure this formula.
Thanks
Mar 07 2022 12:44 PM
=IF(AND(H8>0,OR(B8="Revenues",B8="Capital Infusion")),"ok","Error")
Is this what you are looking for?
Mar 07 2022 12:54 PM
Mar 07 2022 12:57 PM - edited Mar 07 2022 01:17 PM
In a cell in row 8, you could use
=IF(OR(AND(OR(B8={"Revenue","Capital Infusion"}),H8>0),AND(OR(B8={"Expenses","Return of Capital"}),H8<0)),"OK","Error")
In a Data Validation rule of type Custom for H8 and below, you could use formula
=OR(AND(OR(B8="Revenue",B8="Capital Infusion"),H8>0),AND(OR(B8="Expenses",B8="Return of Capital"),H8<0))
Mar 07 2022 01:11 PM
Mar 07 2022 01:18 PM
I forgot a quote. I have corrected my previous reply.
Mar 07 2022 01:25 PM