Hi!
Try this:
=IF(AND(F38,OR(B2={"S","R"})),(F3-8)*K3*1.5,0)
Looks like a time sheet!
Biff
-----Original Message-----
Please help with this formula
=if(B2="s" or "r")and if(F38,(F3-8)*(K3*1.5),0))
The syntax is wrong for sure, I can't get it right.
Thank You,
B
.
|