Good Afternoon,
Slight problem...
I am using this code: =IF(M21*N20 < 1, "", SUM(M21*N20))
N20 is 25.00% in Excel 2016 and M21 is the LINE total. However, unless I have a value in LINE it'll only show #VALUE! instead of NOTHING.
Ideally,
I am trying to aim for if no value present, don't show anything.
I have attached the Purchase Order.xlsm (I have a single macro so far in the workbook) here,
Please let me know what I am doing wrong? I have spent hours researching what's and why's and cannot work it out.
Thank you,
TechXcellent
Bookmarks