Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
101
Views
Topic starter
Hey,
How do you format the cells that are just numbers and not formulas?
Thanks for the reply, Leah
Posted : 07/01/2022 5:43 am
Hello,
From Excel 2013 and newer you have the ISFORMULA function, so you can check if the cell contains a formula or not.
Example: =IF(ISFORMULA(A1),FALSE(),ISNUMBER(A1))
First I check if cell A1 contains a formula, if so then set value FALSE, if not then check if it contains a number.
Br,
Anders
Posted : 07/01/2022 6:27 pm
