Thread: IF(logical_test, may be a number or text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_37_] barry houdini[_37_] is offline
external usenet poster
  
Posts: 10
Default IF(logical_test, may be a number or text
Any text is deemed to be greater than any number.....so when L20 is
text it satisfies the first condition and 500 is returned. Best to use
an IF to check if L20 is a number or not

=IF(ISNUMBER(L20),MEDIAN(0,500,L20),L20)

regards, barry

Reply With QuoteReply With Quote