How to check if a cell contains "%" and calculate accordingly. [Solved/Closed]
N245 -
Mar 24, 2015 at 06:04 PM - Latest reply: MaxStart346
Posts Tuesday March 3, 2015Registration dateContributorStatus
July 3, 2015
Last seen
- Mar 26, 2015 at 04:46 AM
I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do..
Basically, if cell B2 contains a whole number (say 10), then cell C2 returns that flat value, but if cell B2 contains a percentage, then C2 performs a simple equation (i.e.: B2*B1)
It's just I am not sure how to define if a cell has a specific symbol/text so it can perform the equation needed, else disregard.
How I vision it could've been (tried but failed)"
IF(B2="#%", B2*B1, B2) -- if I understood that function correctly, if B2 contains a percentage, it would multiply B2 by B1, if not, it will return B2 value.. regardless of that, it always returns B2 value, even if it is with a percentage.
I think I got this, since I can't get my way to return a true/false value if B2 cell contains the symbol % I just used this formula:
=IF(B2<=1, B2*B1, B2)
Where 100% would be 1.00, 99% would be 0.99 and so on are less than 1.. now it works like a charm. However, if the percentage input is more than 100% it wouldn't work, but I doubt I'd need more than that. Anyhow, I still would like to know if a cell contained a symbol or a text, which expression do I use to return a true/false value for that cell and upon it perform another function?
Could you possibly explain what does the function "right" mean?