Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ian
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Help with array formula Excel Worksheet Functions 2 January 20th 05 04:17 PM
Cell shows formula and not the result of the formula. stumpy1220 Excel Worksheet Functions 2 January 14th 05 05:11 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"