# Variation of IF formula help needed

1. ## Variation of IF formula help needed

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  Register To Reply

2. ## Re: Variation of IF formula help needed

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))))  Register To Reply

3. ## Re: Variation of IF formula help needed

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!  Register To Reply

4. ## Re: Variation of IF formula help needed

Thanks for the Rep... we do it 'cos we're addicted, not for the money!!!  Register To Reply

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1