Formula Check Please!

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.
 
R

Ron Rosenfeld

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)

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))
 
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
 
R

Ron Rosenfeld

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

I'm not a member of Egghead either. This a newsgroup formerly hosted
on the Microsoft news servers; and I access it through my newsreader
(Forte Agent).

Glad to help, and thanks for the feedback.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top