View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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.