Feb 10 2022 07:06 PM - edited Feb 10 2022 08:39 PM
Hey Guys,
I am trying to create a formula that reads the context of a single cell and tells me if it is less than 20. I did write an if statement that works but, I need one that is more complex. For instance, cell A3 contains the number 13 =IF (A2<20, "Loss", "") this tells me it is less than 20. However, if cell A2 has the contents of = 10 + 10 it will show blank per the equation above. I need an equation that can read cell A2 as less than 20 (loss) while still reading cell A3 as a loss. Can this be done?
Feb 10 2022 08:03 PM
Feb 10 2022 08:21 PM
Feb 12 2022 09:51 AM - edited Feb 12 2022 11:13 AM
I am very sorry. I think I misunderstood your question.