Hi there,
Please find attached example of the issue I am having.
I require a formula in cell AB2.
For AB2 i esenntially require an formula stating if the transaction volume (f2) is greater then Band 2 UQ (M2) then (M2-L2)*N2 however if the trans volume is lower then Band 2 LQ (L2) then "0" and if Trans volume is lower then M2 but greater then L2 then (F2-L2)*N2.
just cant get my head around this as not the strongest on the IF formula.
many thanks
excel help 15.05.15.xls
Bookmarks