| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculations in MS excel
I think my first post failed; so i'm re-posting...sorry for cross posings...
Im working on a spreadsheet where I want Column E to be 1/5th of the dollar value in Column D. So far Ive had to enter =MOD(Dx,5) for each D cell (ie x) value. This works for some of the values, yet others auto-calculate wrong. I.e. when I typed in $15.31 in cell D17, it showed $0.31 in E17; and $25.00 auto-calculated as $-. Yet it seems to work correctly for 12.41 and 12.50 values. The cells have been formatted to currency. Can anybody tell me what Im doing wrong and how to correct this problem? Is there a way to format the entire column to reflect 1/5 of the previous columns value so I dont have to retype the formula in every column E cell? A BIG thanks to anyone who can help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Margin of error calculations in excel | Excel Discussion (Misc queries) | |||
| how do I interupt excel 2003 calculations? | Excel Discussion (Misc queries) | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Threaded Mode
