You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
So as title states trying to create a check mark formula where column B is value Column C is Checkmark and column D is negative value or Zero based on checkmark. Added bonus would also love to highlight row too
MacBook Pro 15″, macOS 10.14
Formula in D
=IF(C,-B,0)
or
=IF(C,0,-B)
Highlighting a row is much more complicated. Maybe just highlight the cell?
Formula in D
=IF(C,-B,0)
or
=IF(C,0,-B)
Highlighting a row is much more complicated. Maybe just highlight the cell?
Checkmark formula. Column B has a value say 100. Column C ‘True’ value check mark Column D makes negative value of Column B or remains Zero
