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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
207
abdo meghari
A
M
  • Question
Dashboard
Replies
4
Views
722
awoohaw
awoohaw
V
  • Question
need help in formula
Replies
4
Views
438
VBABEGINER
V
V
  • Solved
Pulling out my hair trying to figure out this formula... please help!
Replies
6
Views
357
smozgur
smozgur
D
  • Question
Error with SUMIFS
Replies
2
Views
369
drewberts
D

Forum statistics

Threads
1,215,038
Messages
6,122,798
Members
449,095
Latest member
m_smith_solihull

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