Jasmine Wrote:
I am trying to write an If statement that uses wild cards, but it is
not
working. My formula looks like =IF(A6="109*",85,IF(A6="110*",75,0)). A6
could
have a value of 109: Consumer Construction 1-4 Family Residential and I
don't
want to have to type out the whole value. Is there a way to do this?
Thanks!


Hi Jasmine

Don't know about wildcards, but this would work

=IF(LEFT(A6,3)="109","85",IF(LEFT(A6,3)="110","75" ,0))


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397813