The data in the cells in column C (numbers) is dependent on what's in the cells in column B (numbers): how can I format cells in column C to be blank unless there's a value in the linked/adjacent cell in B?
Thanks
Thanks
This is a very simple spreadsheet - column B is hours someone's worked & C is the hours * the hourly rate e.g. [=sum(B2*20)], with a cell for the total at the bottom. At the moment all the cells in column C that have no data in the relevant column in B are automatically displaying a '0' - I'd like them to be blank unless there a value in the linked cell in column BWelcome to the Board!
Your question is not quite clear. It sounds like you need a formula in column C, but how does it know what value to be in column C if there is a value in column B?
Maybe you could walk us through an actual example, and it will help clarify things.
=sum(B2*20)
=IF(B2<>0,B2*20,"")
Thanks, I'll try thoseThere are lots of different ways to do that (changing your formula, using Custom Formatting, using Conditional Formatting, etc).
Check out this link for various options, and choose the one you like best!
Display or hide zero values - Microsoft Support
Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.support.microsoft.com
The simplest maybe to change your formula from:
toExcel Formula:=sum(B2*20)
Excel Formula:=IF(B2<>0,B2*20,"")
(also note that the SUM in your original formula serves no purpose, you aren't summing multiple values there, just multiplying one!).