How to check if a cell contains "%" and calculate accordingly.
Solved/Closed
Related:
- If cell contains specific text
- Excel conditional formatting if cell contains specific text - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
2 responses
MaxStart
Posts
339
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 25, 2015 at 07:23 PM
Mar 25, 2015 at 07:23 PM
=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?
Mar 26, 2015 at 04:34 AM
Could you possibly explain what does the function "right" mean?
Mar 26, 2015 at 04:46 AM
Oct 18, 2019 at 02:46 PM