J

#### jeffsmarketplace

I have an IF formula I am using on the below sequence, but it is
returning a 0 instead of results. I am hoping someone can help.

A B C D E F G H
I J K L
M N

15) LEAL1 150 0 72 72 60 4.5 3.2 681.60 230.04 1390.90 69.54 2nd
Sort 54

=IF(M15="2nd Sort",N15*H15)*IF(M15="1st Sort",N15*G15+D15*H15)

J

#### jeffsmarketplace

I have an IF formula I am using on the below sequence, but it is
returning a 0 instead of results. I am hoping someone can help.

A B C D E F G H I J K L M N
15)  LEAL1      150     0       72      72      60      4.5     3.2     681.60  230.04  1390.90 69.54    2nd Sort 54

=IF(M15="2nd Sort",N15*H15)*IF(M15="1st Sort",N15*G15+D15*H15)

J

#### jeffsmarketplace

I have an IF formula I am using on the below sequence, but it is
returning a 0 instead of results. I am hoping someone can help.

A           B     C       D     E      F      G      H
I                J                 K              L
M             N

15)  LEAL1      150     0       72      72      60      4.5     3.2     681.60  230.04  1390.90 69..54    2nd
Sort    54

=IF(M15="2nd Sort",N15*H15)*IF(M15="1st Sort",N15*G15+D15*H15)

I can't seem to fix the column headers in my example they are jumbled.
the LEAL1 is supposed to be column A 150 B so and so forth.

J

#### jeffsmarketplace

You are multiplying the results of two IF statements together.  One of
the IF statements must always evaluate to FALSE.  FALSE times any
value = 0.

If you want to show the result of whichever IF statement is TRUE, then
you should either NEST the statements, or ADD them.

e.g.:

=IF(M15="2nd Sort",N15*H15)+IF(M15="1st Sort",N15*G15+D15*H15)

or

=IF(M15="2nd Sort",N15*H15,IF(M15="1st Sort",N15*G15+D15*H15))

I wanted to thank you for your answer earlier, but I found its
response in another forum I am not a member of (Egghead). Any rate
thank you.

Jeff