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?