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
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 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
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