Tim R
03-09-2012, 04:42 PM
Hello everyone,
'recently converted an excel timesheet to a PDF form. Trying to get some help to convert two excel formulas (formulae?) into javascript.
First Excel formula is intended to return the value of "40" if the total is above 40, otherwise display actual value: =IF(L17>40, 40,L17)
Second excel formula is the "overtime" field, which displays the number of hrs above 40hrs, or displays "N/A" if below 40: =IF(L17>40, L17-40, "N/A")
I have essentially no experience in Javascript and I am trying to learn, but any help to get me over this hump will be appreciated.
Regards
tim
'recently converted an excel timesheet to a PDF form. Trying to get some help to convert two excel formulas (formulae?) into javascript.
First Excel formula is intended to return the value of "40" if the total is above 40, otherwise display actual value: =IF(L17>40, 40,L17)
Second excel formula is the "overtime" field, which displays the number of hrs above 40hrs, or displays "N/A" if below 40: =IF(L17>40, L17-40, "N/A")
I have essentially no experience in Javascript and I am trying to learn, but any help to get me over this hump will be appreciated.
Regards
tim