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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 20, 2013 at 04:01 PM
Hello,
I am creating an excel sheet where I need to have a cell show 55% of a number that will change weekly. How do I set it up where the original number does not show only the adjusted number will?



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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 ""
0