M
marmite
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",IF(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
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",IF(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