If this and that!

Nygie

New Member
Joined
Apr 15, 2015
Messages
40
Nearly there
=IF(D2="Y",IF(Table6[[#This Row],[Gross £]]>865,753*0.01,IF(AND(Table6[[#This Row],[Gross £]]>113,Table6[[#This Row],[Gross £]]<865),(Table6[[#This Row],[Gross £]]-113)*0.01)),0)
Sorry for the table references lol
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Nygie

New Member
Joined
Apr 15, 2015
Messages
40
Thank you both for your replies.
Very helpful, I was nearly there I had my Y/N conditioning met but could not get the formula to do me sums!

Thanks again
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,925
Messages
5,508,138
Members
408,667
Latest member
jh89

This Week's Hot Topics

Top