i put it in cell J2, and when i deleted the value for G2, the formula
just calculated the weight over and when i deleted the value for F2 it
said TARE ONLY in H2 because of the forumula I already created.

If i change the formula where it has the COUNTA(F2:H2)< to 2, then it
Shows the values i need in J2. I need them to show up in F2, G2, or
H2. Does that make sense? The formula looks like this now:

=IF(COUNTA(F2:H2)<2,"",IF(F2<"","Gross only",IF(G2<"","Tare
Only","Net Only")))

I feel we're getting there!


--
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057
View this thread: http://www.excelforum.com/showthread...hreadid=497626