using IF & AND functions in conjunction

  • Thread starter Thread starter Lester
  • Start date Start date
L

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
 
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
Click to expand...

Something like:

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

--ron
 
=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"
 
Back
Top