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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,510
Messages
5,487,310
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top