Formula that can read the contents in a single cell

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3152505%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EFormula%20that%20can%20read%20the%20contents%20in%20a%20single%20cell%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3152505%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHey%20Guys%2C%3CBR%20%2F%3EI%20am%20trying%20to%20create%20a%20formula%20that%20reads%20the%20context%20of%20a%20single%20cell%20and%20tells%20me%20if%20it%20is%20less%20than%2020.%20I%20did%20write%20an%20if%20statement%20that%20works%20but%2C%20I%20need%20one%20that%20is%20more%20complex.%20For%20instance%2C%20if%20a%20cell%20A2%20contains%20the%20number%2013%20%3DIF%20(A2%26lt%3B20%2C%20%22Loss%22%2C%20%22%22)%20this%20tells%20me%20it%20is%20less%20than%2020.%20However%2C%20if%20cell%20A2%20has%20the%20contents%20of%20%3D%2010%20%2B%2010%20it%20will%20show%20blank%20per%20the%20equation%20above.%20I%20need%20an%20equation%20that%20can%20read%20both%20numbers%20separately%20as%20less%20than%2020%20while%20still%20totaling%2020%20in%20cell%20A2.%20Can%20this%20be%20done%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3152505%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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?excel1.JPGexcel4.JPG

 

3 Replies
Have you tried "IsFormula" and "FormulaText" function?
Hi Willy,
Thanks for your reply. Both these functions read the cell as 20 and not reading them as 10 and 10. The cell reads 20 but the equation in the cell is 10+10. I need a formula that can read 10+10 as less than 20. But I also need it to read the cell as greater than or equal to 20 as well. Do you have any more suggestions or do you have an example equation using the above function? I tried : =IF(FORMULATEXT(A6)<20,"loss","") A6 contained only 13 no = or equation, this did not work unfortunately

@AKSA_67 

I am very sorry.  I think I misunderstood your question.