How do i put a cell reference in an If Function? ASAP
 

I have a set of data rangeing from $1-$1000 and my professor wants us to use
the IF function to determine the shipping rate based on the amount of money
from $1-$1000. I am using an IF function and the problem that i ran into was
that i when determining the shipping charges for over $150, he wants us to do
15% of the total cost. So for the IF Function i have,
=IF(H5150,"H5*15%",.........)
the thing is that when the charge is over $150, it displays in the cell
"H5*15%" instead of refernceing the cell and multiplying it by 15%.......for
Excel 2003

any suggestions...THANKS SOOO MUCH

How do i put a cell reference in an If Function? ASAP
 

Just leave out the double-quote marks:
=IF(H5150,H5*.15,"not over 150")
you can put 0 for the "not over 15" if you like, or ,"") just to not show
anything.

By using the " symbol(s) you told Excel to treat what is between them as a
string literal (a bunch of words) and to display that rather than the actual
calculation.

Let me know if I pass <g
"Robbie" wrote:

I have a set of data rangeing from $1-$1000 and my professor wants us to use
the IF function to determine the shipping rate based on the amount of money
from $1-$1000. I am using an IF function and the problem that i ran into was
that i when determining the shipping charges for over $150, he wants us to do
15% of the total cost. So for the IF Function i have,
=IF(H5150,"H5*15%",.........)
the thing is that when the charge is over $150, it displays in the cell
"H5*15%" instead of refernceing the cell and multiplying it by 15%.......for
Excel 2003

any suggestions...THANKS SOOO MUCH

How do i put a cell reference in an If Function? ASAP
 

Thanks SOOOO MUCH...your information was very helpful!!!

"JLatham" wrote:


Just leave out the double-quote marks:
=IF(H5150,H5*.15,"not over 150")
you can put 0 for the "not over 15" if you like, or ,"") just to not show
anything.

By using the " symbol(s) you told Excel to treat what is between them as a
string literal (a bunch of words) and to display that rather than the actual
calculation.

Let me know if I pass <g
"Robbie" wrote:

I have a set of data rangeing from $1-$1000 and my professor wants us to use
the IF function to determine the shipping rate based on the amount of money
from $1-$1000. I am using an IF function and the problem that i ran into was
that i when determining the shipping charges for over $150, he wants us to do
15% of the total cost. So for the IF Function i have,
=IF(H5150,"H5*15%",.........)
the thing is that when the charge is over $150, it displays in the cell
"H5*15%" instead of refernceing the cell and multiplying it by 15%.......for
Excel 2003

any suggestions...THANKS SOOO MUCH