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 :)

1)

=MAX(90,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)))))))

2) the result of yuor formula will be one of the numbers
2000,2500....9000 or it will be 90, which occurs when
Employees exceeds 500. I can't see where you'd get a
number like 50 from.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
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",I F
(Employees<501,"£9000","£0
"))))))

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

tia :)


.

oh blimey, sorry dont know what's wrong with me...i meant this formula!!!

=IF(B40,0.3*(B4/100),IF(B499999,0.28*(B4/100),IF(B4199999,0.24*(B4/100),I
F(B4499999,0.2*(B4/100),IF(B4999999,0.19*(B4/100),IF(B42499999,0.17*(B4/1
00),IF(B44999999,0.15*(B4/100),IF(B410000000,"Refer","£0"))))))))

and the minimum needs to be £90 :)

"Patrick Molloy" wrote in message
...
1)

=MAX(90,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)))))))

2) the result of yuor formula will be one of the numbers
2000,2500....9000 or it will be 90, which occurs when
Employees exceeds 500. I can't see where you'd get a
number like 50 from.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
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",I F
(Employees<501,"£9000","£0
"))))))

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

tia :)


.

=IF(B4="",0,IF(B410000000,"Refer",MAX(90,VLOOKUP( B4,{0,0.3;99999,0.28;19999
9,0.24;499999,0.2;999999,0.19;2499999,0.17;4999999 ,0.15},2,1)*B4/100)))




--
Regards,
Tom Ogilvy

wrote in message
...
oh blimey, sorry dont know what's wrong with me...i meant this formula!!!


=IF(B40,0.3*(B4/100),IF(B499999,0.28*(B4/100),IF(B4199999,0.24*(B4/100),I

F(B4499999,0.2*(B4/100),IF(B4999999,0.19*(B4/100),IF(B42499999,0.17*(B4/1
00),IF(B44999999,0.15*(B4/100),IF(B410000000,"Refer","£0"))))))))

and the minimum needs to be £90 :)

"Patrick Molloy" wrote in message
...
1)

=MAX(90,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)))))))

2) the result of yuor formula will be one of the numbers
2000,2500....9000 or it will be 90, which occurs when
Employees exceeds 500. I can't see where you'd get a
number like 50 from.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
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",I F
(Employees<501,"£9000","£0
"))))))

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

tia :)


.