numbers formula

how do i write a mac formula saying : if cell b2 is true then cell e2 equals E1 minus d2 in mac numbers

Mac mini, macOS 13.4

Posted on Jul 8, 2023 6:33 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 8, 2023 6:41 AM

Use:


=IF(B2=TRUE,E1−D2,"")


in E2.


(241618)

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

numbers formula

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