LinkBack URL
About LinkBacks
Thank you so much for your assistance.
What can I do when K21 is zero? Multplying it by J21*1.8 would format a cell in red as per the conditional formatting when it shouldn't.
Cell J21 has $500
Cell K21 has $0
=IF(K21>J21,(IF(J21>0,K21>=J21*1.8)))
Thank you so much for your assistance.
What can I do when K21 is zero? Multplying it by J21*1.8 would format a cell in red as per the conditional formatting when it shouldn't.
Cell J21 has $500
Cell K21 has $0
=IF(K21>J21,(IF(J21>0,K21>=J21*1.8)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks