View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marmite@demon.co.uk is offline
external usenet poster
 
Posts: 5
Default Minimum Cell Value

Hi,

Wondered if anybody could help me..

I need a cell to display a minimum value of £90 and to intergrate that into
this formula:

=IF(Employees<21,"£2000",IF(Employees<51,"£2500",I F(Employees<101,"£3000",IF
(Employees<251,"£5000",IF(Employees<376,"£7000",IF (Employees<501,"£9000","£0
"))))))

So, if the result from the formula is..say, £50...then it is automatically
increased to £90.

tia :)