Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 19th 21, 04:59 PM posted to microsoft.public.excel.worksheet.functions
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?

  #2   Report Post  
Old April 3rd 21, 01:48 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 56
Default IF statement: how do I simply return the calculation in theconditional as one of the outcomes?

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))



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I perform calculation within IF statement? Steven Masterson Excel Worksheet Functions 4 December 15th 08 08:13 AM
Can I use symbols in an If statement as outcomes? JuliaC Excel Worksheet Functions 1 April 24th 07 11:14 PM
If statement + date calculation DP7 Excel Programming 1 February 8th 07 04:35 PM
return calculation every four weeks [email protected] Excel Discussion (Misc queries) 1 May 11th 06 12:15 PM
IF statement with 3 possible outcomes djmillis Excel Worksheet Functions 2 November 12th 04 03:13 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017