IF Function

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
If your sequence continues in the same progression, try this:

=CEILING(C18/5,1)*2.5

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
You don't need an if function nor a lookup. A direct calculation will do the
job:
=INT((C18+4.9999)/5)*2.5

Bob Umlas
Excel MVP
 
Ron's formula will work unless C18 is 0, so you may need to add an i
statement.

=IF(C18=0,2.5,CEILING(C18/5,1)*2.5)

If 0 should return 0 then just use Ron's formula
 
Back
Top