N245 - - Latest reply:
MaxStart

- Posts
- 346
- Registration date
- Tuesday March 3, 2015
- Status
- Contributor
- Last seen
- July 3, 2015

Related:

- Excel check if cell is percentage
- Excel if percentage - Best answers
- If cell contains percentage excel - Best answers
- Excel check if cell contains date ✓ - Forum - Office Software
- Excel: If Date =, then enter a value ✓ - Forum - Excel
- Excel check if cell is filled with color - How-To - Excel
- Excel check if cell contains one of several values ✓ - Forum - Excel
- If date in cell is greater than date in cell ✓ - Forum - Office Software

Best answer

MaxStart

- Posts
- 346
- Registration date
- Tuesday March 3, 2015
- Status
- Contributor
- Last seen
- July 3, 2015

=IF(RIGHT(B2,1)="%",B2*B1,B2)

please follow-up with us if it works for you.

--

Damn it !!!, is it ever gonna be the way I want it to be?

A few words of thanks would be greatly appreciated. Add comment

4460 users have said thank you to us this month

venkat1926

- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015

=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?