juvena Wrote:
I confused about creating formula using if function for the condition
below.

Labor costs for items with material costs of at least $100 but less
than
$500 are estimated at 50% of material costs.

I tried everything but did not work please help

(for example A1 contains a material cost) =if(A1=100<500,A1*0.50)
isn't
that correct?

Hi juvena

Try this =IF(AND(A1=100,A1<=500),A1*0.5,"")


--
Paul Sheppard


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