Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Get next Integer value

If I Dim i As Integer
and then test "A1" for its' value
and if the value in "A1" is 3.00000000000000 and 1

How can I return i = 4 , please?

ie any value 3 but < 4 returns 4

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Count Whole / Integer Only?	1.4 1.6 2.7 3.1	Excel Worksheet Functions	3	May 1st 23 07:45 PM
How do I add an integer to an existing integer?	Aaron	Excel Worksheet Functions	3	December 17th 09 09:46 PM
non-integer scrollbar	Brad	Charts and Charting in Excel	3	November 7th 07 03:27 AM
integer	integer format	Excel Worksheet Functions	1	May 3rd 07 06:45 PM
Not seeing integer	Martin Wheeler	Excel Programming	1	September 4th 03 03:29 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us