Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
I would like this formula to work only if the value in O188 is a number. If
it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
Maybe,
=IF(ISNUMBER(O188),IF(O188=$E188,1,0),0) Mike "carl" wrote: I would like this formula to work only if the value in O188 is a number. If it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
=IF(ISNUMBER(O188),IF(O188=$E188,1,0),0)
Note that arguments are separated by commas, not semicolons. Tyro "carl" wrote in message ... I would like this formula to work only if the value in O188 is a number. If it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
=IF(AND(ISNUMBER(O188);O188=$E188);O188;0)
On 23 Mar, 20:20, carl wrote: I would like this formula to work only if the value in O188 is a number. If it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
Note that arguments are separated by commas, not semicolons
Depends on where you live and what your regional settings are. -- Biff Microsoft Excel MVP "Tyro" wrote in message ... =IF(ISNUMBER(O188),IF(O188=$E188,1,0),0) Note that arguments are separated by commas, not semicolons. Tyro "carl" wrote in message ... I would like this formula to work only if the value in O188 is a number. If it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify A Formula
Another one:
=COUNT(O188)*(O188=E188) You also might want to test E188 as well: =(COUNT(E188,O188)=2)*(O188=E188) -- Biff Microsoft Excel MVP "carl" wrote in message ... I would like this formula to work only if the value in O188 is a number. If it is not a number, return 0 (zero). =IF(O188=$E188;1;0) Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify Excel Formula | Excel Worksheet Functions | |||
Modify A formula | Excel Worksheet Functions | |||
Modify a formula | Excel Discussion (Misc queries) | |||
Modify A Formula To Include AND | Excel Worksheet Functions | |||
Modify A SumProduct Formula | Excel Worksheet Functions |