Getting Value with Two Decimal at different places

G

gillani77

New member
Joined
Jun 18, 2014
Messages
17
Reaction score
0
Points
1
Excel Version(s)
office2013
Hi All,
I am trying to write a Nested If the formula for more than 7 arguments. Below is my formula and answer received.

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)))))
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.
 
How do we know where the result came from.

Better to post an actual sample workbook showing your setup and expected results...
 
Take a look at the formula on cell H46 of the sheet Sheet1!.
=INDEX($M$43:$M$60,MATCH(H42,$L$43:$L$60))
 

Attachments

  • ExcelGuru8854.xlsx
    43 KB · Views: 8
Thanks All, particularly p45cal. Please accept my sincere apologies to get back to you with this delay, as I was switched over to another project.
 
You must log in or register to reply here.
Back
Top