I have a formula in my sheet that will fill in a specific field with the text JobBOMPrt if there is a quantity greater than 0 in another coordinating field. I recently ran into an issue where i have a negative quantity and now need to modify the formula so that it will fill in that text if there is anything other than 0 or a blank cell.
Any help would be great.
=IF($H11>0,(CONCATENATE($A11,"JobBOMPrt")),"")
How about:
=IF(AND($H11<>0,$H11<>""),(CONCATENATE($A11,"JobBOMPrt")),"")
Same formula logic, just done backwards:
=IF(OR($H11={0,""}),"",$A11&"JobBOMPrt")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks