Multiple arguments with multiple answers

[mactoolsix]

For cell M50, If B50>20 then M50 = 100 but if M49>1 then M49 * 1.5

If I then copy M50 to M51,M52, M53, M54 etc, once M50 has a number the following cells will multiply that previous cell value by 1.5.

If B50 is never >20,then all M values = 0
Once B50, or B51, B52, B53 etc >20, then corresponding M = 100
Then the next cell in column M would be 100 * 1.5

Hope that's clearer than mud!
Thanks, Mike

 

[mactoolsix]

Yep, I have (had) two problems.
The "FALSE" when Column B is less than the RetYr

And the #VALUE problem = which is now solved.

 

[mactoolsix]

Yes I had two problems - the #VALUE ! problem has been solved.

Okay, here's what I've got:

B50 = IF(B49 < FinalYr,B49+1,"") correctly returns 2058 (above I told you "20" trying to keep things simple)
FinalYr is 2086
B49 = 2057

K50 = IFERROR(F50+G50+I50+J50,0) correctly returns 0
L50 = IF(B50 < RetYr,L49*(1+Inflation),"") correctly returns ""
M50 = IF(AND(B50 < > "",B50 > RetYr-1),IF(M49 < > 1,M49*(1+Inflation),FirstYrAnnExp)) correctly returns 180,100
Inflation = .03
FirstYrAnnExp = 174,855

RetYr is 2057

When column B is less than the RetYr column M returns "FALSE"
Is there a way around that?

Thanks!

 

[mactoolsix]

jtakw,
Sorry if I have offended you. I was merely trying to get an answer to two problems that were on the same spreadsheet.
Looks like I've been "turned off" to any further help.
I feel bad as I've always found this board a great help . . . .
Mike

 

[jtakw]

No Mike, that's not the case.

I thought I already gave you my suggested solution in Post #10 of this thread.
I suspect the problem is the SAME as your other problem on the other thread.
Go back to page 1 of this thread and read my Post #10 .
You indicated that L50 = IF(B50 < RetYr,L49*(1+Inflation),"") correctly returns ""
Whenever you try to do math on cells that contain a "" or " " using the plus ( + ) or minus ( - ) sign, it will throw a #VALUE error, by using SUM, it coerces excel to treat the "" or " " as 0.

If this doesn't solve your problem, I'll need to examine your actual file.