| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Function to look at two cells and return a third | Excel Worksheet Functions | |||
Linear Mode
