I’m trying to make a formula that does different things under different conditions in different cells. What I have is:
IF(BM16=−1,1,"O")
This produces the letter ‘O’ for open in my case.
What I want is the above plus if BK16 is >0 and/or if BM16 is greater than >-1 then the cell will produce a blank. Can this all be done in one formula?
Another way, and possibly better, to do this in my sheet would be IF(BM16=−1,1,"O") plus check for a string generated in an adjacent cell by a different conditional: resulting in the above formula plus IF ‘string’ in a specified cell = X OTM, then generate a blank cell.
Best Answer
Replace the "0" by the second formula
anything after = is a formula and can be used where you want a value