Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Desperate help needed on formula
Hi all,
really struggling with this one......... I am trying to create a commision sheet where by when certain percentages are reached different pay levels are met..... ie <75% = £35 76-100% = £45 101 = £55 I have tried using if formulas but will only give me a choice of two not three :-( Any ideas?????? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Desperate help needed on formula
Try the below and feedback..
Using IF statements... =IF(A1<75,35,IF(A1<=100,45,IF(A1100,55))) Alternatively if you have more conditions use LOOKUP will ease a bit easy for you to edit and reuse... =LOOKUP(A1,{0,1,75,101},{0,35,45,55}) If this post helps click Yes --------------- Jacob Skaria "prabbetts" wrote: Hi all, really struggling with this one......... I am trying to create a commision sheet where by when certain percentages are reached different pay levels are met..... ie <75% = £35 76-100% = £45 101 = £55 I have tried using if formulas but will only give me a choice of two not three :-( Any ideas?????? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Desperate help needed on formula
try this idea to start at the top
=if(a1100,55,if(a175,45,35)) -- Don Guillett Microsoft MVP Excel SalesAid Software "prabbetts" wrote in message ... Hi all, really struggling with this one......... I am trying to create a commision sheet where by when certain percentages are reached different pay levels are met..... ie <75% = £35 76-100% = £45 101 = £55 I have tried using if formulas but will only give me a choice of two not three :-( Any ideas?????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE | Excel Worksheet Functions | |||
If Formula - Desperate for help | Excel Discussion (Misc queries) | |||
HELP! In desperate need of a formula | Excel Discussion (Misc queries) | |||
if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions |