I have a working nested calculation, but I need to add another condition to.
In the cell after taking into account the nested calculation I need to have to total of that cell = no less than $100. So any total from $0.00-$99.99 needs to equal $100. attached below is an example of the nested calculation.
=IF(D34<=4.5,(H4*0.2),IF(D34<=9.5,SUM(H4*0.25)+(I4*0.05),IF(D34<=15.5,SUM(H4*0.3)+(I4*0.1),IF(D34<=19.5,SUM(H4*0.35)+(I4*0.1),IF(D34,SUM(H4*0.4)+(I4*0.1),"")))))*D4
I'm not bad so completely self taught, so there may be some basics I have missed or may not use all the proper jargon.
Thanks!
In the cell after taking into account the nested calculation I need to have to total of that cell = no less than $100. So any total from $0.00-$99.99 needs to equal $100. attached below is an example of the nested calculation.
=IF(D34<=4.5,(H4*0.2),IF(D34<=9.5,SUM(H4*0.25)+(I4*0.05),IF(D34<=15.5,SUM(H4*0.3)+(I4*0.1),IF(D34<=19.5,SUM(H4*0.35)+(I4*0.1),IF(D34,SUM(H4*0.4)+(I4*0.1),"")))))*D4
I'm not bad so completely self taught, so there may be some basics I have missed or may not use all the proper jargon.
Thanks!