Solved EXCEL PROGRAM need certain answers with 4 different outcomes

March 16, 2016 at 03:17:57
Specs: Windows 7
okay, I have been trying to figure this out and I am at my wit's end; CHOULD SOMEONE HELP ME PLEASE??

This is what I need done:

miles price is different for certain amount of miles;
1-5 miles is 7.
6-10 miles is 5.5
11-15 miles is 4.
and 16 -19 miles is 2.5

expample:
My driver took a product of the travel distance of 16 miles which is milage pay of 2.5
but the next delivery that was done is 6, than 8, and so forth. Each time it is different.
I figured out that this formula should work for what I need, but it will not compute the anser without me having to search and manually put it in.
The formula that I can up with is:

(A33<H42>B33=C33;A34<H42>B34=C34;A35<H42>B35=C35;A36<H42>B36=C36)

with line 33 being 1-5 miles is 7.
line 34 being 6-10 miles is 5.5
line 35 being 11-15 miles is 4.
and line 35 being 16 -19 miles is 2.5
H42 is the milage

Does anoyone have an idea how to make it work with the EXCEL PROGRAM?
Thanks


See More: EXCEL PROGRAM need certain answers with 4 different outcomes

Report •


✔ Best Answer
March 22, 2016 at 04:18:10
Are you using Excel or Open Office?

I see semi-colons in your original post, which may indicate Open Office. If so, try changing the commas to semi-colons.

Even if you have no milage rate for greater than 19, you should still have the formula return something. If you don't deal with that situation, then the formula will probably return FALSE, which I consider to be sloppy.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03



#1
March 16, 2016 at 06:34:44
re: "CHOULD SOMEONE HELP ME PLEASE??"

Please do not post in All Caps. All Caps is the internet equivalent of yelling and no one likes to yelled at.

I think this is what you are asking for, but I'm not 100% sure:

=IF(A1<=5,A1*7,IF(A1<=10,A1*5.5,IF(A1<=15,A1*4,IF(A1<=19,A1*2.5,"Mileage is Greater Than 19"))))

I added the "Mileage is Greater Than 19" result because you did not tell us what the rate is for trips longer than 19 miles.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 22, 2016 at 01:11:40
Sorry if it sounds as if I am yelling, it is just that this is fustrating me to no end.
Thank you for advising me the formula, however, there is no set amount for the 19 plus miles. I have to add the 19 milage rate with a different milage rate. Which is kind of >.<... And the formula is saying an error, so I think it may not work. But thankyou very much for helping me. By any chance, would you know a different one that could work for me?

Report •

#3
March 22, 2016 at 02:53:53
And the formula is saying an error, so I think it may not work.

The formula DerbyDad03 offered works fine for me.

It would help if you posted what the error message is. Just reporting there is an error does not help much.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
March 22, 2016 at 04:18:10
✔ Best Answer
Are you using Excel or Open Office?

I see semi-colons in your original post, which may indicate Open Office. If so, try changing the commas to semi-colons.

Even if you have no milage rate for greater than 19, you should still have the formula return something. If you don't deal with that situation, then the formula will probably return FALSE, which I consider to be sloppy.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •


Ask Question