About Us

Spencer101

Quote:

Originally Posted by Planko

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

Hi all,

The above formula is what I need help with. I get the figure I want but the problem is that 'Page 1'!F45 might not have a percentage in it to calculate the total. So if I45 has 100% in it and F45 is 0%, or blank, then I get 50% for my total. I need it to say 100% if the second calculation is 0% or blank. The second calculation might not need to have anything in it to figure the numbers needed. If there is a calculation in F45 the formula works just fine.

Thanks for any help,

Planko

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.

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

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

Menu

About Us