Help with Formulas

(1) I have a formula where G4 is the product of D4 and F4. But when nothing is inputted into the formula, $0.00 is displayed in G4. I do not want to see that $0.00. I want that cell to be completely blank until there are digits in D4 and F4. How do I edit the format to have the result cell to be blank?


(2) Can I duplicate what is in one cell to another? I want E4 to automatically be the exact same as D4, but I do not see that formula.


(3) Can a specific prompt be inserted whenever a specific cell has something inputted into it? If something is inputted into G4, and the text "Thank you" automatically appear in F4?

Posted on Nov 9, 2022 10:58 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 9, 2022 4:22 PM

(1) Try creating a Custom Format like this (first scroll to the bottom of the dropdown under Data Format in the Cell tab after you've selected Format, and click Create Custom Format...)



(2) With E4 selected type = to call up the formula editor and click on D4, then accept the formula.


(3) In cell F4 try the formula =IF(LEN(G4)>0,"Thank you","")





SG



Similar questions

1 reply
Sort By: 
Question marked as Top-ranking reply

Nov 9, 2022 4:22 PM in response to sraff57

(1) Try creating a Custom Format like this (first scroll to the bottom of the dropdown under Data Format in the Cell tab after you've selected Format, and click Create Custom Format...)



(2) With E4 selected type = to call up the formula editor and click on D4, then accept the formula.


(3) In cell F4 try the formula =IF(LEN(G4)>0,"Thank you","")





SG



Reply

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.

Help with Formulas

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