Please log in or register. Registered visitors get fewer ads.
Forum index | Previous Thread | Next thread
Excel Extrordinaire Experts Explanation Expected.. 11:27 - Feb 28 with 789 viewsMeadowlark

OK. Here's a question for you Excel superusers. (See Really obvious stuff thread)
I have columns of calculations based upon daily readings.
How do I make future days' SUMs show as blank cells until I have entered the readings? Currently, these cells for tomorrow, the day after, etc are populated with random numbers based upon constants and other factors in the calculations.
The daily readings cells are obviously blank until they are entered.
I'm not a professional Excel user so please make it easy...
0
Excel Extrordinaire Experts Explanation Expected.. on 11:51 - Feb 28 with 747 viewsGuthrum

=if(cell where the reading is input="","",your calculation)

In other words, if the input cell is blank, that cell will also be. Otherwise it will show the calculation. It may be commas or semicolons in Excel, I can't remember.
[Post edited 28 Feb 2020 11:53]

Good Lord! Whatever is it?
Poll: McCarthy: A More Nuanced Poll
Blog: [Blog] For Those Panicking About the Lack of Transfer Activity

0
Excel Extrordinaire Experts Explanation Expected.. on 15:27 - Feb 28 with 657 viewsMeadowlark

Excel Extrordinaire Experts Explanation Expected.. on 11:51 - Feb 28 by Guthrum

=if(cell where the reading is input="","",your calculation)

In other words, if the input cell is blank, that cell will also be. Otherwise it will show the calculation. It may be commas or semicolons in Excel, I can't remember.
[Post edited 28 Feb 2020 11:53]


Thanks. I'll give it a try.

This seems to work.

=IF(OR(ISBLANK(INPUT cell),ISBLANK(input cell)),"",(calculation))

[Post edited 28 Feb 2020 16:13]
0
Excel Extrordinaire Experts Explanation Expected.. on 15:49 - Feb 28 with 639 viewsLord_Lucan

If you have something very complicated Jake_ITFC is your man.

I employ him from time to time on a remuneration chicken bargain bucket basis.

“Hello, I'm your MP. Actually I'm not. I'm your candidate. Gosh.” Boris Johnson canvassing in Henley, 2005.
Poll: How will you be celebrating Prince Phils life today

0
Excel Extrordinaire Experts Explanation Expected.. on 16:15 - Feb 28 with 615 viewsMeadowlark

Excel Extrordinaire Experts Explanation Expected.. on 15:49 - Feb 28 by Lord_Lucan

If you have something very complicated Jake_ITFC is your man.

I employ him from time to time on a remuneration chicken bargain bucket basis.


It's ALL complicated for me!!

But I just made a breakthrough, so I'll persevere!
0
Excel Extrordinaire Experts Explanation Expected.. on 16:49 - Feb 28 with 597 viewsmanchego

Funny really. I read that as 'Incel' Extrardinaire Experts Explanation Expected.

That would have been a great thread.
0
About Us Contact Us Terms & Conditions Privacy Cookies Advertising
© TWTD 1995-2024