Tim - Not exactly clear what you want to do but a couple of things I
think might be easier to accomplish.
=IF(H2=10,IF(U2=1,"$",1),IF(L3=1,IF(U2=1,"$",IF(W2 =1,"Trl",1)),0))
If you fill down - your second "IF" statement (L3=1) gets overwritten
when you copy down. Also you have U2=in there twice.
I would try using an AND statement something like the following:
=IF(AND(H2=10,U2=1),"$",IF(W2=1,"TRL",0))
In my limited function knowledge - your first "IF" statement should
have a "value" if "TRUE" and not another IF statement. Use the second
IF Statment for the "FALSE" part of the IF function - which is what my
example is trying to show you. If you use the AND function - when you
close it you will get an error message - just ignore it - go to the
formula area of the spreadsheet - put the cursor on the "IF" statement
you need to complete and then hit the "equal" sign.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=494968