How to add two cells when one uses IF function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(AA29>350.99,"17.75",IF(AA29>250.99,"15.95",IF(AA29>99.99,"10.95",IF(AA29>49.99,"9.95",IF(AA29>9.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.
 
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
 
It works fine now. Thank you!

Jim May said:
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
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

How to use "count if" with criteria within a cell? 2
how to add values of cells only if a corresponding cell has information on it 1
How to add todays date (static) to the current active cell using m 5
How do you change a NULL value to a Zero when using =MID function? 6
Using IF to reference two cells 3
How to copy a cell with an if-function? 2
HOW DO I USE TWO IF FUNCTIONS IN ONE CELL? 1
Using IF function in excel to search for text across cells and she 7

Back
Top