How do I create an IF statement that will display:

£ 0 to£4,745 = "No tax"
£4,746 to£6,765 = "10%"
£6,766 to£36,145 = "22%"
£36,146 + = "40%"

The figure it is to look at will be C365.

Jamie


--
JamieLPD
------------------------------------------------------------------------
JamieLPD's Profile: http://www.excelforum.com/member.php...o&userid=31386
View this thread: http://www.excelforum.com/showthread...hreadid=510792