Calculation with a Blank or 0 Cell

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by Spencer101

Hi Planko,

You need IF statements in there to do this. It would be easier to show you how if you could post an example workbook.

S.

Actually, scrap that. Give this a try....

=IFERROR(IF(OR(F45=0,F45=""),I45,('Page 1'!I45+'Page 1'!F45)/2),"N/A")

Does that do what you need?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I omit a blank cell from a calculation??	marklg	Excel Worksheet Functions	5	September 2nd 08 10:16 AM
Return Blank from Cell Calculation	Spreadsheet Geek[_2_]	Excel Worksheet Functions	2	February 21st 08 07:29 PM
How to leave a formula cell blank when it has no calculation to make	Colin Hayes	Excel Discussion (Misc queries)	9	May 13th 07 04:41 AM
Blank cell calculation	Duane	Excel Discussion (Misc queries)	1	April 20th 06 08:45 PM
Finding the first non-blank cell in a row and then applying a calculation	[email protected]	Excel Programming	3	January 24th 06 03:10 PM

All times are GMT +1. The time now is 10:12 PM.

About Us