Discounts on excel

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,627
Office Version
365
Platform
MacOS
sorry missed a comma out

try this
=IF( D26<5, 7.5*D26, IF(D26<10, 7*D26, D26*6.5))
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

edreid95

New Member
Joined
Nov 23, 2013
Messages
8
For some reason, when i reply on here, it missed out parts of the formula!
=IF( D26<5, C26*D26) IF(4<D26<10, 7*D26) IF(D26>10,6.5*D26)
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,627
Office Version
365
Platform
MacOS
leave a space between the characters , as it can try and do a web tag
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,990
1 to 47.517.5
5 to 9757.25
10 to 146.75106.75
15 to 196.5156.5
20 plus6.25206.25
how manyprice each
77.25
the table on the right
is called mytable
formula in price each cell
=VLOOKUP(A14,mytable,2)
you can put extra columns in my tabl
for golf balls and ping pong balls

<colgroup><col span="3"><col><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,090,298
Messages
5,413,641
Members
403,496
Latest member
chamshop

This Week's Hot Topics

Top