# Excel assistance

Closed
njiebadou Posts 2 Registration date Tuesday March 3, 2015 Status Member Last seen March 4, 2015 - Mar 3, 2015 at 06:01 AM
njiebadou Posts 2 Registration date Tuesday March 3, 2015 Status Member Last seen March 4, 2015 - Mar 4, 2015 at 07:04 AM
Hello,
Can i PLEASE get some help with this problem? 5KM or more and less than 15km, the cost will be 5... Thanks to everyone in advance
Related:

## 1 response

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Mar 3, 2015 at 08:22 AM
Looks like an "If" statement will do the trick.
Assuming your value is in A1 you might try this:
=IF(AND(A1>5,A1<15),5,0)

You could also set it up so variables are cells
Assuming the target value is 12 and in A3, the min is in A4, the max is in A5, the cost in A6 and the "other" cost is in A6 (you could also use "" to make it blank blank or 0 to show a zero for the "other" cost. You could use
=IF(AND(A3>A4,A3<A5),A6,A7)

What you're doing is saying if the two conditions are both met, use the cost. If not use zero.

As I'm writing it, I'm saying to myself - "IF AND the amount is greater that five and the amount is less than fifteen then five else zero."

Hope that helps.
njiebadou Posts 2 Registration date Tuesday March 3, 2015 Status Member Last seen March 4, 2015
Mar 4, 2015 at 07:04 AM
Thank you soooooo much, i can't thank you enough, This will surely help.