Microsoft Office Forums - View Single Post - Price with different break points

Thread: Price with different break points

View Single Post

Old

12-06-2017, 02:26 PM

abc3132

abc3132 is offline

abc3132 uses Windows 7 64bit

Windows 7 64bit abc3132 uses Office 2007

abc3132 uses Office 2007

Office 2007

Novice

The original poster

Join Date: Feb 2015

Posts: 24

abc3132 is on a distinguished road

Default

Thanks NBVC
I´m afraid that your solution did not work.
However this one yes:
=IF(AND(A4>1;A4<VLOOKUP(B4;F3:M5;7;FALSE));VLOOKUP (B4;F3:M5;6;FALSE);0)
Cheers

Reply With Quote