Forum Home
Press F1
 
Thread ID: 7399 2001-01-21 07:17:00 Excel Functions? Guest (0) Press F1
Post ID Timestamp Content User
8108 2001-01-21 07:17:00 I am trying to write a formula to give me the nearest number to a particular number in a cell.
eg 1.045 is closest to which of the following : 1.040,1.039,1.046,2.342,1.044 without going over the actual number...

I have 600-700 numbers to check so doing it manually is silly...
Guest (0)
1