How you go about this would depend on how specific or generic you name the
items. Do you just name a food item 'food' or would you put 'bread', 'peanut
butter' etc? If you just give them generic names like 'food', 'cleaning' etc
you could try somehting like this formula:

=IF(A1="Food",0.02,(IF(A1="Cleaning",0.03,IF(A1="B ooks",0.04))))

This will check the contents of A1 and put in a tax rate depending on what
is entered in A1. You could then just copy this formula down the column.
(You would also format this column as percentage.)

"lsmft" wrote:


LOL,
Not sure yet. I'm still scratching my head on this one. I think I may
have gone in over my head here. Thanks much though and I'll see if I
can find how to use that.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=548118