using IF & AND functions in conjunction

[Lester]

help me with:

if a1=A
and sum(c3:c8)<40
charge "rate A" x number of hours
else charge "rate B" X number of hours

thanks

 

[Ron Rosenfeld]

help me with:

if a1=A
and sum(c3:c8)<40
charge "rate A" x number of hours
else charge "rate B" X number of hours

thanks

Something like:

=IF(AND(A1="A",SUM(C3:C8)<40), Rate_A*NumHrs, Rate_B*NumHrs)

--ron

 

[Peo Sjoblom]

=IF(AND(A1=A,SUM(C3:C8)<40),A*SUM(C3:C8),B*SUM(C3:C8))

note that I assumed that A is not text but a numeric rate and that it is
SUM(C3:C8) that you want to multiply with the different rates..
If A is text enclose it with quotations "A"