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.

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

Numbers if True False Space

Hi,


I have a problem,


If the cell is empty, I want it to write blank. How can I do it?


Posted on Jan 12, 2023 1:06 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 12, 2023 3:20 PM

Here is another idea for you.



Use column D to enter your equations as actual Numbers formulas. It will compute the correct answers.


Column A will display the equation from column D using the FORMULATEXT function

A2 =TEXTAFTER(FORMULATEXT(D2);"=")&"="


C2 =IFS(B2="";"";B2=D2;TRUE;B2<>D2;FALSE)

I changed this formula a little from my last post and it gets the correct answer from column D


Hide column D so the answers are not visible.




4 replies
Question marked as Top-ranking reply

Jan 12, 2023 3:20 PM in response to oguzhancakmak

Here is another idea for you.



Use column D to enter your equations as actual Numbers formulas. It will compute the correct answers.


Column A will display the equation from column D using the FORMULATEXT function

A2 =TEXTAFTER(FORMULATEXT(D2);"=")&"="


C2 =IFS(B2="";"";B2=D2;TRUE;B2<>D2;FALSE)

I changed this formula a little from my last post and it gets the correct answer from column D


Hide column D so the answers are not visible.




Numbers if True False Space

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