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

Level 1

8 points

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

Best reply

SGIII

Level 8

35,528 points

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","")

View in context

Help with Formulas

Similar questions