![]() |
#3
|
||||
|
||||
![]()
Hi Andrew,
I'd suggest: =MIN(1,400/A1)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |
![]() |
Corca | Excel | 6 | 02-22-2010 09:40 PM |
![]() |
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
![]() |
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |