Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results inconsistent.
I have created a multiple-worksheet workbook designed to be a monthy credit
card transaction log. In my summary, I calculate the difference of the total amount of entries inputted into the log and a field to put in the total from the machine. This field, which uses an IF statement, displays "N/A" if a machine value hasn't been inserted, amount of difference, or "None" if the difference is zero. The only problem is, even though the difference should be zero, sometimes the difference isn't zero. Even though the formulas are straightforward and shouldn't be producing insignificant fractions of a penny, they are. Here's the formula flow: Cell 1: [=SUMIF(F5:F34,"0")] - Adds up credit card charges. (0 is there because sheet also handles credit card credits) Cell 2: [No formula] - User enters total amount from machine Cell 3: [=IF(Cell 2="","N/A",IF(Cell 1-Cell 2=0,"None",Cell 1-Cell 2))] What I'm wondering is how Cell 3's formula could be producing something like $0.000000000000227373675443232000. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results inconsistent.
On Sun, 15 Oct 2006 06:54:02 -0700, CyberTootie
wrote: I have created a multiple-worksheet workbook designed to be a monthy credit card transaction log. In my summary, I calculate the difference of the total amount of entries inputted into the log and a field to put in the total from the machine. This field, which uses an IF statement, displays "N/A" if a machine value hasn't been inserted, amount of difference, or "None" if the difference is zero. The only problem is, even though the difference should be zero, sometimes the difference isn't zero. Even though the formulas are straightforward and shouldn't be producing insignificant fractions of a penny, they are. Here's the formula flow: Cell 1: [=SUMIF(F5:F34,"0")] - Adds up credit card charges. (0 is there because sheet also handles credit card credits) Cell 2: [No formula] - User enters total amount from machine Cell 3: [=IF(Cell 2="","N/A",IF(Cell 1-Cell 2=0,"None",Cell 1-Cell 2))] What I'm wondering is how Cell 3's formula could be producing something like $0.000000000000227373675443232000. See: http://support.microsoft.com/kb/214118/en-us --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results inconsistent.
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results inconsistent.
Thanks!
"Ron Rosenfeld" wrote: On Sun, 15 Oct 2006 06:54:02 -0700, CyberTootie wrote: I have created a multiple-worksheet workbook designed to be a monthy credit card transaction log. In my summary, I calculate the difference of the total amount of entries inputted into the log and a field to put in the total from the machine. This field, which uses an IF statement, displays "N/A" if a machine value hasn't been inserted, amount of difference, or "None" if the difference is zero. The only problem is, even though the difference should be zero, sometimes the difference isn't zero. Even though the formulas are straightforward and shouldn't be producing insignificant fractions of a penny, they are. Here's the formula flow: Cell 1: [=SUMIF(F5:F34,"0")] - Adds up credit card charges. (0 is there because sheet also handles credit card credits) Cell 2: [No formula] - User enters total amount from machine Cell 3: [=IF(Cell 2="","N/A",IF(Cell 1-Cell 2=0,"None",Cell 1-Cell 2))] What I'm wondering is how Cell 3's formula could be producing something like $0.000000000000227373675443232000. See: http://support.microsoft.com/kb/214118/en-us --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |