How to check if a cell contains "%" and calculate accordingly.
Solved/Closed
Related:
- Excel string contains
- Count if cell contains number - Excel Forum
- Check soft - Download - Finance
- How to calculate position in excel ✓ - Office Software Forum
- How to check if someone is spying on my whatsapp - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel 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