Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Help....;o)
I have this formula : =IF(K10=1,I10*K10,K10-I10) and it keeps coming up with looks like some type of rounding. I have no condition formats set in these cells nor anything else, they are just formulas. Maybe someone knows of a better formula I can use. The thing is I have to have to make sure that the "total" column stays at zero dollars so that my sum function works at the end of the column. Thanks in advance. I K L UNIT PRICE QUANTITY * TOTAL** $10.00 -6 -$16.00 GRAND TOTALS: -$16.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Excel Rounding Issue | Excel Discussion (Misc queries) | |||
Sum Issue Help! | Excel Discussion (Misc queries) | |||
Rounding issue with Goal Seek for IRR | Excel Worksheet Functions | |||
Another rounding issue | Excel Worksheet Functions |