Thread: IF statement: how do I simply return the calculation in theconditional as one of the outcomes?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Terranova David Terranova is offline
external usenet poster
  
Posts: 1
Default IF statement: how do I simply return the calculation in theconditional as one of the outcomes?
For example, this is what I'm doing currently (simplified the calculation for clarity):

if(A1*B1 < 1, "", A1*B1)

This works fine but isn't there a way to simply return the calculation without having to repeat it manually as one of the returns?
Reply With QuoteReply With Quote