Hide the formula

[Closed]
Report
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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 ""