info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
IF statement: how do I simply return the calculation in the conditional as one of the outcomes?
43 views
Skip to first unread message
David Terranova
Mar 19, 2021, 12:59:21 PM3/19/21
to
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?
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?
MyVeryOwnSelf
Apr 2, 2021, 8:48:55 PM4/2/21
to
=LET(answer, A1*B1 , IF(answer<1, "", answer))
0 new messages