N245 -
Mar 24, 2015 at 06:04 PM - Latest reply:
MaxStart

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

- Excel check if cell is percentage
- Excel if percentage - Best answers
- Excel check if cell contains date ✓ - Forum - Office Software
- Excel: If Date =, then enter a value ✓ - Forum - Excel
- If date in cell is greater than date in cell ✓ - Forum - Office Software
- If Cell A1 has text then Cell B2 has Today's Date - Forum - Excel
- How to check multiple cells to return value? - Forum - Excel

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?

venkat1926

- Posts
- 1865
- 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?