Apple Intelligence is now available on iPhone, iPad, and Mac!

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.