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.

How do I hide a value in a cell waiting data?

I am trying to create a spreadsheet for payroll with the simple cell formula =PRODUCT(0.75,Cell). When I try to drag the formula down the column, it is automatically inserting 0.75 in the cells that are don't have data yet, which is then messing up my formulas summing the entire column. Is there a way I can get the formula not to calculate a value until a value is put into the cell? I tried the ISBLANK function but it still keeps it as 0.75. I have currently been adding the value at each payroll then dragging the formula down one row at a time, but wondering if there is a way to do this where I can apply the formula to the entire spreadsheet.


I feel like I'm back in high school so frustrated learning excel :)


Thanks in advance.



MacBook Pro 13″, macOS 10.12

Posted on Feb 24, 2022 7:54 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 24, 2022 9:15 PM

tamkg wrote:

I feel like I'm back in high school so frustrated learning excel :)


This is a forum for Numbers, not Excel.😀 But spreadsheets can be hard!


In either Numbers or Excel you can use an IF statement, something like this:



The formula in C2:


=IF(B2,PRODUCT(0.75,B2),"")


Or, if your region uses , as a decimal separator:


=IF(B2;PRODUCT(0,75;B2);"")


The IF statement looks at B2. If there is a value there it returns 0.75 times that value. If there is no value there it returns the null character (the ""). That makes the cell look blank.


So you can enter that formula in C2 (or a cell in whatever column) and fill (drag) or copy the formula down the rest of the column, rather than having to enter it or drag it cell-by-cell.


You can learn more about how to use the IF statement, including useful examples, here. Remember you can always look up how to make formulas via Help > Formulas and Functions Help in your menu.


SG


Similar questions

2 replies
Question marked as Top-ranking reply

Feb 24, 2022 9:15 PM in response to tamkg

tamkg wrote:

I feel like I'm back in high school so frustrated learning excel :)


This is a forum for Numbers, not Excel.😀 But spreadsheets can be hard!


In either Numbers or Excel you can use an IF statement, something like this:



The formula in C2:


=IF(B2,PRODUCT(0.75,B2),"")


Or, if your region uses , as a decimal separator:


=IF(B2;PRODUCT(0,75;B2);"")


The IF statement looks at B2. If there is a value there it returns 0.75 times that value. If there is no value there it returns the null character (the ""). That makes the cell look blank.


So you can enter that formula in C2 (or a cell in whatever column) and fill (drag) or copy the formula down the rest of the column, rather than having to enter it or drag it cell-by-cell.


You can learn more about how to use the IF statement, including useful examples, here. Remember you can always look up how to make formulas via Help > Formulas and Functions Help in your menu.


SG


How do I hide a value in a cell waiting data?

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