- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
need jsl formula to account for empty cell in conditional if statement
Hi - I am new to jsl scripting and am trying to construct a jsl statement as follows:
if column A is empty, column C = empty,
else if column A < 500 and column B = 200, column C = 0,
else if column A>500, column C = 1.
How would I frame a jsl formula to do this? Thanks!
10 REPLIES 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: need jsl formula to account for empty cell in conditional if statement
Thanks Ron. It's working now!
- « Previous
-
- 1
- 2
- Next »