Connecting 2 IF(AND) statements

**Speedyjrr** · 05-27-2013, 06:23 PM

Greetings-

I am working on a spreadsheet and I need to know how to connect 2 IF(AND) formulas/statements. I have tried several ways to connect the two formulas into one but I just can't figure it out.

I have attached the spreadsheet I am working on. Basically, in want to combine the 2 IF(AND) formulas in cells K3 & K5 so that when the route count is changed from 1 to 2, the amount will also change from $40 (when 2 is imputed) to $20 (when 1 is imputed). Just a side note, when a date is entered into cell I, then the formula is correct in displaying $0.00.

Thanks in advance for your help!

**FDibbins** · 05-27-2013, 07:12 PM

Not sure I understand what you want, but try this...

=IF(AND(H3="Yes",I3="Yes"),J3*20,0)

**Speedyjrr** · 05-27-2013, 08:09 PM

Here in a nut shell is what I am looking to do. I have these 2 formulas and I want to put them together so that depending on what is entered in cells H, I and J will return the correct result.

=IF(AND(H3="Yes",I3="Yes",J3=2),40,0)
=IF(AND(H5="Yes",I5="Yes",J5=1),20,0)

For instance, the formula in row 3 is correct for the route status of 2, but is a one is entered as a 1, then the output of the formula should be $20.00 as in row 6.

**Speedyjrr** · 05-27-2013, 08:12 PM

I just tried the formula you gave and it worked! I never would have thought of that! I've been working on this for about a week and a half and I guess I was making to way to complicated!