My bad ... I figured it out.

Thanks again!

--
Krista


"Krista" wrote:

Yes, that's what I mean -- thanks.

I tried this formula; however, nothing is appearing. I initially thought
that's what the formula should be; however, it's not calculating ... the
field is blank.

Thanks.
--
Krista


"SteveG" wrote:


Krista,

Do you mean if the first 3 characters are "12x" or first 2 are "6x"?

Try,


=IF(E33="","",IF(LEFT(E33,3)="12x",F33*0.7*0.8,IF( LEFT(E33,2)="6x",F33*0.7*0.5,0)))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=552424