**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.*