View Single Post
  #1   Report Post  
Old March 19th 21, 04:59 PM posted to microsoft.public.excel.worksheet.functions
David Terranova David Terranova is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2021
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?