Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
No problem Sandy. I can't guarantee being around on a regular basis so I'm
quite happy for someone to offer suggestions "on my behalf" as it were. -- Ian -- "Sandy Mann" wrote in message ... Hi Ian, I'm glad that you are around now - I always think that it is impertinent to suggest changes to other people's formulas, especially if they are perfectly capable of doing so themselves. I kind of fell into it by accident, my apologies. -- Regards Sandy Replace@mailinator with @tiscali.co.uk "Ian" wrote in message ... Try changing the 1000 to 998. -- Ian -- "Lynn" wrote in message ups.com... I really appreciate everything you have helped me with. Everything is working with this, except 2 numbers... When I plug in 1,000 and 999; I should be getting 6.24 and I get 6.54. 1,000/2 = 500 which should be 2.24 500/250 is 2*2 for 4.00 999/2 = 499.5 (in reality is 500) for 2.24 500/250 is 2*2 for 4.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with array formula | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |