| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I cant get this to work:(
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
Thank You,
Yes it is a time sheet with s and r being variables of determining if O.T. is paid or not. Brian "Biff" wrote: 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
| how is possible working on work sheet by two person in the netwo. | Excel Worksheet Functions | |||
| The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
