| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
our cost to customers cost
in one cell would like to display our cost, in another the formula for cust.
cost. the formula only works on the high end and the low end, everything in the mid. won't work,can anyone please help me out ? =IF(A150,A1*1.4,A1*1.55,IF(A1<25,A1*1.8,IF(A1<6,A 1*2.45,IF(A1<5,A1*2.85, IF(A1<3,A1*3.25,IF(A1<1,A1*5.8,A1*4)))))) Would I need an = infront of each IF statement ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| our cost to customers cost | Excel Worksheet Functions | |||
| How many different customers in a list? | Excel Worksheet Functions | |||
| Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions | |||
| What Bus. templete do I use for daily cost w/ daily & cum cost ? | Excel Discussion (Misc queries) | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
Threaded Mode
