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
again
User
09/02/2018 - 12:57
IF(B48>=RetYr-1,IF(M47>1,M47*(1+Inflation),FirstYrAnnExp))
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
IF(B48>=RetYr-1,IF(M47>1,M47*(1+Inflation),FirstYrAnnExp),0)
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
work
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.