View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
lotus lover lotus lover is offline
external usenet poster
 
Posts: 6
Default excel 2003 IF function question

thanx max
--
craig phila


"Max" wrote:

"David Biddulph" <groups [at] biddulph.org.uk wrote:
=IF(AN7="","",IF(AN7<0.375,0.375,AN7))
or
=IF(AN7="","",MAX(0.375,AN7))


Yes. Thanks for refinements, David.
Guess I was too hung up with the front IF part of it <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---