Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Can you tell a formula not to calculate if another cell has characters in it?
|
#2
![]() |
|||
|
|||
![]()
Hi
=IF(ISNUMBER(A1),"calculate","don't calculate") -- Regards Frank Kabel Frankfurt, Germany "Roxanne Ruiz" schrieb im Newsbeitrag ... Can you tell a formula not to calculate if another cell has characters in it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |