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.