| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total the column anyway
I need a way to use my formula even when there is no discount.
I 45 Tuition $1596.00 46 Registration Fee $25.00 47 Textbook $75.00 48 Group Discount 5% 49 Total I45-(I45*I48)+I46+I47 Formula works, but what if there's no discount? If cell I48 is blank then I get #value. I want it to total my numbers even if there is no discount. Thanks for looking at this. Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Threaded Mode
