Hide the formula
Closed
collvetter
rizvisa1
- Posts
- 1
- Registration date
- Wednesday February 20, 2013
- Status
- Member
- Last seen
- February 20, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Hide the formula
- How to show or hide formula bar in Excel: VBA, shortcut - Guide
- Spreadsheet formula - Articles
- How to know if someone hide their story from you on instagram - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to hide app store on ipad - Guide
1 reply
rizvisa1
Feb 20, 2013 at 04:01 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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 ""