Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

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

Posted on Sep 8, 2021 1:49 PM

Reply
Question marked as Best answer

Formula in D

=IF(C,-B,0)

or

=IF(C,0,-B)


Highlighting a row is much more complicated. Maybe just highlight the cell?


Posted on Sep 8, 2021 8:15 PM

1 reply

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.