Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Given: RetYr = 2057 B48=2055 B49=2056 B50=2057 FirstYrAnnExp = 174,855 B51=2058 M48=IF(B48>=RetYr-1,IF(M47>1,M47*(1+Inflation),FirstYrAnnExp)) Returns FALSE M49=IF(B49>=RetYr-1,IF(M48>1,M48*(1+Inflation),FirstYrAnnExp)) Correctly retuns 0 M50=IF(B50>=RetYr-1,IF(M49>1,M49*(1+Inflation),FirstYrAnnExp)) Correctly returns 174,855 M51=IF(B51>=RetYr-1,IF(M50>1,M50*(1+Inflation),FirstYrAnnExp)) Correctly returns 180,100 How can I avoid “FALSE” when the B column is less than RetYr? A zero or blank would be better.
Solved by V. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/02/2018 - 12:50
Welcome, Thanks for choosing Got It Pro-Excel How may I help you today?
User 09/02/2018 - 12:54
How can I get rid of the FALSE in J48 ?
Excelchat Expert 09/02/2018 - 12:54
Can you please type the formula gai
Excelchat Expert 09/02/2018 - 12:54
User 09/02/2018 - 12:57
Excelchat Expert 09/02/2018 - 12:58
What do you want in place of False?
User 09/02/2018 - 12:58
A blank of a zero
Excelchat Expert 09/02/2018 - 12:58
IF(B48>=RetYr-1,IF(M47>1,M47*(1+Inflation),FirstYrAnnExp)," ")
Excelchat Expert 09/02/2018 - 12:58
Check if this works
User 09/02/2018 - 01:00
it makes row 49 and up blank, however now the rows below that are = #VALUE!
Excelchat Expert 09/02/2018 - 01:00
Excelchat Expert 09/02/2018 - 01:01
Check with thi
Excelchat Expert 09/02/2018 - 01:01
if this doesn
Excelchat Expert 09/02/2018 - 01:01
Excelchat Expert 09/02/2018 - 01:01
I will need to see the data or atleast an example
Excelchat Expert 09/02/2018 - 01:01
Please create a new session for that
User 09/02/2018 - 01:01
OK changed the "" to a zero - fixed!
Excelchat Expert 09/02/2018 - 01:02
Done right?
Excelchat Expert 09/02/2018 - 01:02
Is there anything else you want to know regarding this issue?
User 09/02/2018 - 01:02
Looks like it
Excelchat Expert 09/02/2018 - 01:02
Thanks for using Got It Pro-Excel Please give your kind feedback for our service Have a good day ahead!
Excelchat Expert 09/02/2018 - 01:04
You may want to end the session now
Excelchat Expert 09/02/2018 - 01:04
Please don't navigate away before ending the session

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc