Discounts on excel

etaf

Well-known Member
sorry missed a comma out

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

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
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
leave a space between the characters , as it can try and do a web tag

oldbrewer

Board Regular
 1 to 4 7.5 1 7.5 5 to 9 7 5 7.25 10 to 14 6.75 10 6.75 15 to 19 6.5 15 6.5 20 plus 6.25 20 6.25 how many price each 7 7.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>

edreid95

New Member
=if( d26<5, c26*d26 ) if( 4<d26<10, 7*d26 ) if( 9<d26, 6.5*d26 )

edreid95

New Member
You did it!!!!!!!!!! thanks so sos so much!!!!