Multiple If Function

[nitin002002]

Greetings,

I am trying to nest if formula but unfortunately ending up with an error

I need to calculate 2 separate cells as follows


If Cell "A1" is equal to 100% and cell "D1" is equal to 150%, then my calculation should be based on cell "D1" . And I have several parameters for the same.

Criteria :-

1) 90% - 100/- AED
2) 100% - 150/- AED
3) Special - 200/- AED

So I am using two formulas separately ..

For cell "A1" I am calculating as follows:-


=if(a1<90%,0,if(a1<100%,100,150)

for cell "D1" I am calculating as follows:-

=if(d1<100%,0,200)

but now I need to nest all of the nested formula in 1.

Please help!!!!!

 

[Joe4]

Not quite sure I completely understand how you are combining these (what all the different conditions and rules are), but perhaps this will get you started.
You can use the AND function to check for multiple conditions, i.e.

=IF(AND(A1=100%,D1=150%),...

Also, here are a few links on the web that talk about nesting IF functions in Excel:
http://spreadsheets.about.com/od/tipsandfaqs/qt/nested_if.htm
MS Excel: Nested IF Functions (WS)

If you run into trouble, post back with more details (maybe with some actual examples and your expected results).