Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weird interger calculation
I try to create formulas to calculate parking meter 'feeding' combination and
get the INTERGER (=int) function problem: DATA: and FORMULA: Cell 'B1' is the number of minutes : 45 minutes for a Quarter (A2) =INT(B1/A2) 18 minutes for a Dime (A3) =INT((B1-(B2*A2))/A3) 9 minutes for a Nickel (A4) =INT((B1-((B2*A2)+(B3*A3)))/A4) With "160 minutes" (@ B1) I get correct calculations for Quarter (3) and Dime (1) but REZO for Nickel (supposedly= 1). If I remove the =INT in formula for Nickel, I get the correct answer '1' (but I also get the decimal in other cases!) With "151 minutes" (@ B1) I get correct for Quarter (3), but REZO for Dime (supposedly 1) and ONE for Nickel (supposedly 0). If I remove the 'INT' formula, I get '0.888889' for Dime AND 2 (TWO) for Nickel! Is that weird? Any explanation is deeply appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |