View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jesse CH Jesse CH is offline
external usenet poster
 
Posts: 4
Default Excel 2000, RAND and IF functions do not work together for me

So whether the cell is formatted to 0 decimal places or not, the IF function
checks all decimals. Dang. Thank you, though.
--
-Jesse CH


"Mike H" wrote:

Jesse,

See my other reply, you never will, there are just too many numbers between
1 and 6 for it to be likely you will ever hit any integer let alone the one
you want 3.

Mike