IF THEN Formula required

[paul w]

help needed formula in D1

only if there is any data in A1 and C1 is >40 then (C1-40)*0.37
only if there is any data in B1 and C1 is >40 then (C1-40)*0.27

only need it to calculate if C1 is greater than 40
if there is nothing in C1 dont run the formula
A1 or B1 will never both be populated at the same time
thanks in anticipation
paul

 

[njimack]

Excel Workbook
	A	B	C	D
1	10		50	3.7
Sheet1

 

[njimack]

Better approach...

Excel Workbook
	A	B	C	D
1	10		50	3.7
Sheet1

 

[Dryver14]

just in case A1 or B1 are both empty

<TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR><TD>=MAX((C1-40)*IF(A1,0.37,0.27),0)</TD></TR></TBODY></TABLE>=IF(AND(A1<>"",C1>40),(C1-40)*0.37,IF(AND(B1<>"",C1>40),(C1-40)*0.37,""))
<TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR><TD>=MAX((C1-40)*IF(A1,0.37,0.27),0)</TD></TR></TBODY></TABLE>

 

[paul w]

thanks to both of you the formula incase a1 and b1 are both empty is just saying false, any ideas, this is what im using to suit the cells on my sheet.

=MAX((L6-40)*IF(J6,0.37,0.27),0)=IF(AND(J6<>"",L6>40),(L6-40)*0.37,IF(AND(K6<>"",L6>40),(L6-40)*0.37,""))=MAX((L6-40)*IF(J6,0.37,0.27),0)

 

[Dryver14]

=IF(AND(A1<>"",C1>40),(C1-40)*0.37,IF(AND(B1<>"",C1>40),(C1-40)*0.37,""))

returns a blank cell if A1 and B1 are empty otherwise it will calculate if C1 is greater than 40

I'm not sure how the other 2 formulas got in my last answer