Thread: Nested If statement revisited
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default Nested If statement revisited
Of course the "<" should have been "=".

In article ,
JE McGimpsey wrote:

And since XL coverts TRUE/FALSE values to 1/0, respectively, in math
operations, you could simplify this a bit mo

=(B10<"X") * 2 * MAX(A2,B2)
Reply With QuoteReply With Quote