50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…","categoryID":317,"dateInserted":"2015-04-29T16:47:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-29T20:26:49+00:00","insertUserID":1183,"insertUser":{"userID":1183,"name":"Daniel Thornton","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Thornton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-22T10:13:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":190,"lastUser":{"userID":190,"name":"Allie","url":"https:\/\/community.smartsheet.com\/profile\/Allie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-22T18:33:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":740,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/202\/can-you-return-a-blank-cell-in-a-formula-that-isnt-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/202\/can-you-return-a-blank-cell-in-a-formula-that-isnt-text","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
