Thread
:
Modify A Formula
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_]
external usenet poster
Posts: 896
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.
Reply With Quote
Jarek Kujawa[_2_]
View Public Profile
Find all posts by Jarek Kujawa[_2_]