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.511-15 miles is 4.and 16 -19 miles is 2.5expample: My driver took a product of the travel distance of 16 miles which is milage pay of 2.5but 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:(A33B33=C33;A34B34=C34;A35B35=C35;A36B36=C36)with line 33 being 1-5 miles is 7.line 34 being 6-10 miles is 5.5line 35 being 11-15 miles is 4.and line 35 being 16 -19 miles is 2.5H42 is the milageDoes 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

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. 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.

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.MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
March 22, 2016 at 04:18:10