Hi All,
I am trying to write a Nested If the formula for more than 7 arguments. Below is my formula and answer received.
[TABLE="width: 218"]
<tbody>[TR]
[TD="class: xl67, width: 218"]IF(H42<=J38,J39,IF(H42<=K38,K39,IF(H42<=L38,L39,IF(H42<=M38,M39,IF(H42<=N38,N39,IF(H42<=O38,O39,IF(H42<=P38,P39,0)))))))&IF(H42<=Q38,Q39,IF(H42<=R38,R39,IF(H42<=S38,S39,IF(H42<=K40,K41,IF(H42<=L40,L41,IF(H42<=M40,M41,IF(H42<=N40,N41,0))))))&IF(H42<=O40,O41,IF(H42<=P40,P41,IF(H42<=Q40,Q41,IF(H42>=R40,R41,0)))))[/TD]
[/TR]
</tbody>[/TABLE]
Answer: 6499.49
As you can see i have two decimalsat two diferent places. This does not allow me to use this value in another formula. CAn someone help me in fixing up my IF formula please.
****** id="cke_pastebin" style="position: absolute; top: 72.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl70, width: 113"]6.499.49[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl70, width: 113"]6.499.49[/TD]
[/TR]
</tbody>[/TABLE]
</body>
I am trying to write a Nested If the formula for more than 7 arguments. Below is my formula and answer received.
[TABLE="width: 218"]
<tbody>[TR]
[TD="class: xl67, width: 218"]IF(H42<=J38,J39,IF(H42<=K38,K39,IF(H42<=L38,L39,IF(H42<=M38,M39,IF(H42<=N38,N39,IF(H42<=O38,O39,IF(H42<=P38,P39,0)))))))&IF(H42<=Q38,Q39,IF(H42<=R38,R39,IF(H42<=S38,S39,IF(H42<=K40,K41,IF(H42<=L40,L41,IF(H42<=M40,M41,IF(H42<=N40,N41,0))))))&IF(H42<=O40,O41,IF(H42<=P40,P41,IF(H42<=Q40,Q41,IF(H42>=R40,R41,0)))))[/TD]
[/TR]
</tbody>[/TABLE]
Answer: 6499.49
As you can see i have two decimalsat two diferent places. This does not allow me to use this value in another formula. CAn someone help me in fixing up my IF formula please.
****** id="cke_pastebin" style="position: absolute; top: 72.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl70, width: 113"]6.499.49[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 113"]
<tbody>[TR]
[TD="class: xl70, width: 113"]6.499.49[/TD]
[/TR]
</tbody>[/TABLE]
</body>