Excel to Javascript formula assistance
Can someone please assist w/ a formula conversion Excel to javascript? The Excel formula is:
FIELD1=IF(B3<1,"",((I3*12+U3))+(IF(S3<1,0,((S3-K3)/3))))
What I have so far is listed below up to the "???"; adding the 2nd "IF" is what's throwing me off...
if (B3<1)
FIELD1=null;
else
FIELD1=
((I3*12)+(U3))+ ???
Any help is greatly appreciated. Thanks!
|