How can I run different calculations based on different criteria?

[BWEL]

Hello Guys,

It's my first post an my Excel knowledge is pretty basic, so please pardon my ignorance in advance.

I am trying to accomplish the following formula.

I have to caculate the percentage of a loan based on the following:

D3 and H3 are Currency Labels
D4 is deposit amount that the customer has already and H4 is credit amount requested
D7 is depost percentage as compared to credit amount requested (i.e. D4 is 60% of H4 amount)
if the deposit percentage covers 100% of H4 then I need a set of cells to be summed up
if the deposit percentage covers in between 80% to 100% then I need another set of cells to be summed up
and if the Currency Labels don't match, meaning the D4 deposit is in another currency from the H4 loan currency then I want a different calculation to be runned that will include currency conversion rates.

Which function should I use to create such a formula?

I've been trying with IF:
=IF(D7>=1,D14+H7+H6,0)

but I can only achieve a basic function and whenever I try to add:
=IF(D7>=0.8 AND D7<1,(D9*(D14+H7+H6),0)

I can't find a way to put them together in one single formula.

Also how do I define the criteria of MATCHING CURRENCY labels in D3 and H3 and non-matching so it can run a different set of calculations?

Any help would be appreciated and once again thanks in advance for bothering to look.

CHEERS

 

[VoG]

Try

=IF(AND(D7>=0.8,D7<1),D9*(D14+H7+H6),0)

 

[BWEL]

Thanks

=IF(AND(D7>=0.8,D7<1),D9*(D14+H7+H6),0)

This worked just fine. Thank you so much. Is there anyway I could incorporate: =IF(D7>=1,D14+H7+H6,0) AND =IF(AND(D7>=0.8,D7<1),D9*(D14+H7+H6),0) ? I know many IFs can be in the same string, but what buffles me is whether these IFs may confuse each-other. I am continuing to study more on the topic so I can have a clearer idea, but meanwhile if anyone would suggest an example, that would be quite fantastic.

THANKS

 

[BWEL]

How do I connect these expressions together?

I kind of figured out somehow how to put things together, but right now I am stuck in making this formula happen.

=IF(EXACT(C3,G3)=TRUE,
IF(AND(CELLVALUE>=0.8,CELLVALUE<1),CALCULATION ONE,0
+
IF(AND(CELLVALUE>=1),CALCULATION TWO,0
AND IF FALSE
IF(AND(CELLVALUE>=0.8,CELLVALUE<1),CALCULATION THREE,0
+
IF(AND(CELLVALUE>=1),CALCULATION FOUR

Trying to make this happen, but somewho I am lost in the commas and the brackets, somewhere I am doing something wrong. Any help to make sense of it and punctuate it properly so that excel can accept it, would be greatly appreciated. THANK YOU GUYS!