How would IF function be used here,Please HELP!

Status
Not open for further replies.
R

rawnaah

New Member
Joined
Apr 18, 2013
Messages
10
251 TO 400 KM & >400 $24 PER MT PER KM
101 TO 250 KM $25 PER MT PER KM
31 TO 100 KM $25 PER MT PER KM
11 TO 30 KM $25 PER MT PER KM
<=10 $600 PER MT PER KM

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>


One IF function incorporating all of the above arguments Please?


Thanks.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

A
  • Question
populate & update invoice information across sheets based on invoice number
Replies
0
Views
205
abdo meghari
A
M
  • Question
Dashboard
Replies
4
Views
721
awoohaw
awoohaw
V
  • Question
need help in formula
Replies
4
Views
437
VBABEGINER
V
V
  • Solved
Pulling out my hair trying to figure out this formula... please help!
Replies
6
Views
356
smozgur
smozgur
D
  • Question
Error with SUMIFS
Replies
2
Views
368
drewberts
D

Forum statistics

Threads
1,214,909
Messages
6,122,189
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top