How to add two cells when one uses IF function?
 

Hi,

I am preparing an invoice form in Excel 2003. I want to do a sub-total
including the shipping cost (which is the result of an IF function). Right
now, it won't count the shipping charge and people that will be using this
form cannot copy/paste values every time.

Example:

Cell AA29 is 30.00

Cell AA30 is
=IF(AA29350.99,"17.75",IF(AA29250.99,"15.95",IF( AA2999.99,"10.95",IF(AA2949.99,"9.95",IF(AA299. 99,"8.95","6.95")))))

Cell AA31 should sum AA29 and AA30 but it doesn't count the value appearing
in AA30.

Any idea?
Thx.

How to add two cells when one uses IF function?
 

In your formula you are instructing excel to enter the various amount AS TEXT
via putting them in quotes " "; REmove the quotes and see if that doesn't
cure
the problem...
HTH
Jim May

"Nat" wrote:

Hi,

I am preparing an invoice form in Excel 2003. I want to do a sub-total
including the shipping cost (which is the result of an IF function). Right
now, it won't count the shipping charge and people that will be using this
form cannot copy/paste values every time.

Example:

Cell AA29 is 30.00

Cell AA30 is
=IF(AA29350.99,"17.75",IF(AA29250.99,"15.95",IF( AA2999.99,"10.95",IF(AA2949.99,"9.95",IF(AA299. 99,"8.95","6.95")))))

Cell AA31 should sum AA29 and AA30 but it doesn't count the value appearing
in AA30.

Any idea?
Thx.

How to add two cells when one uses IF function?
 

It works fine now. Thank you!

"Jim May" wrote:

In your formula you are instructing excel to enter the various amount AS TEXT
via putting them in quotes " "; REmove the quotes and see if that doesn't
cure
the problem...
HTH
Jim May

"Nat" wrote:

Hi,

I am preparing an invoice form in Excel 2003. I want to do a sub-total
including the shipping cost (which is the result of an IF function). Right
now, it won't count the shipping charge and people that will be using this
form cannot copy/paste values every time.

Example:

Cell AA29 is 30.00

Cell AA30 is
=IF(AA29350.99,"17.75",IF(AA29250.99,"15.95",IF( AA2999.99,"10.95",IF(AA2949.99,"9.95",IF(AA299. 99,"8.95","6.95")))))

Cell AA31 should sum AA29 and AA30 but it doesn't count the value appearing
in AA30.

Any idea?
Thx.