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
Last edited by moe1986; 05-15-2015 at 10:59 AM.
I think this works for all of the examples shown!!
=IF(F2>=M2,(M2-L2)*N2,IF(F2<L2,0,IF(AND(F2>=L2,F2<M2),F2-(L2*N2))))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn,
Many thanks for the response Really appreciate your help.
Just a slight note, i changed the last bit of the formula from F2-(L2*N2) to (F2-L2)*N2
.
Many thanks for your help.
if i could tip you i would but guess adding reputation will have to do!
Thanks for the Rep... we do it 'cos we're addicted, not for the money!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks