Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum Cell Value
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 :) . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum Cell Value
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 :) . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum Cell Value
=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 :) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set a minimum value for a cell | Excel Discussion (Misc queries) | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
cell minimum value of zero ? | Excel Discussion (Misc queries) | |||
Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
How can I set a minimum value of zero or -100% in a cell? | Excel Worksheet Functions |