Hide the formula
Closed
collvetter
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
-
Feb 20, 2013 at 01:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2013 at 04:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2013 at 04:01 PM
Related:
- Hide the formula
- Steam hide comments - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Platinum hide ip - Download - VPN
- Excel vba hide formula bar - Guide
- Potplayer hide controls - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 20, 2013 at 04:01 PM
Feb 20, 2013 at 04:01 PM
Lets say that number is in cell A1
and you want to show in B1 the 55% of it
then
in B1
=IF(isnumber(A1), a1 * 0.55, "")
so if a1 is a number, then show 55% else show ""
and you want to show in B1 the 55% of it
then
in B1
=IF(isnumber(A1), a1 * 0.55, "")
so if a1 is a number, then show 55% else show ""
