1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • IF statement: how do I simply return the calculation in the conditional

    From David Terranova@21:1/5 to All on Fri Mar 19 09:59:18 2021
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From MyVeryOwnSelf@21:1/5 to David Terranova on Fri Apr 2 17:48:53 2021
    On Friday, March 19, 2021 at 9:59:21 AM UTC-7, David Terranova wrote:
    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?

    Maybe this will help (using Excel 360 and Windows 10):
    =LET(answer, A1*B1 , IF(answer<1, "", answer))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)