G
Guest
I have a range of numbers that I need Excel to perform a function based on
the conditions. The formula I wrote works fine for what I need it to do, but
I can't next beyond 7 expressions. I know someone said I should use LOOKUP to
do this, but I know nothing about the LOOKUP function and I'm not a math
whiz, so I'm lost on that.
Basically, here is the formula that I currently have:
=if(c18=0,0, if(c18<=5, 2.50, if(c18<=10, 5.00, if(c18<=15, 7.50))))
{There is more to the formula, but hopefully that gives the idea}
I have a list of numbers for payments for minutes of transcription that I
need to be able to put in the amount of time transcribed, and have it return
the proper amount.
0-5 minutes = 2.50
5-10 minutes = 5.00
11-15 minutes = 7.50
Et cetera
The problem is this goes up to 55-60 mintues = 30.00
If I could nest more than seven expressions, this would work fine, as it
does the job up to seven. What do you do, though, when you need more than 7?
There is a total of 12 conditions here.
the conditions. The formula I wrote works fine for what I need it to do, but
I can't next beyond 7 expressions. I know someone said I should use LOOKUP to
do this, but I know nothing about the LOOKUP function and I'm not a math
whiz, so I'm lost on that.
Basically, here is the formula that I currently have:
=if(c18=0,0, if(c18<=5, 2.50, if(c18<=10, 5.00, if(c18<=15, 7.50))))
{There is more to the formula, but hopefully that gives the idea}
I have a list of numbers for payments for minutes of transcription that I
need to be able to put in the amount of time transcribed, and have it return
the proper amount.
0-5 minutes = 2.50
5-10 minutes = 5.00
11-15 minutes = 7.50
Et cetera
The problem is this goes up to 55-60 mintues = 30.00
If I could nest more than seven expressions, this would work fine, as it
does the job up to seven. What do you do, though, when you need more than 7?
There is a total of 12 conditions here.