Adding formulas based on range names
 

Hi,

I have a workbook with three sheets(inputs, overrides, actuals) calle
Demand I, Demand O and Demand A. Each row is range named betwee
columns J and T, with the same name on each sheet, with the exceptio
of the prefixes DCI, DCOV and DCA dependant upon sheet. I would lik
to add a formula to every cell in Demand A column J that is a part of
range name such that the formula is;

=if(and(DCO_overrides_enabled=TRUE,DCOV_blahblah< ""),DCOV_blahblah,DCI_blahblah)

where DCOV/DCI blahblah is the range name used on the current row.
Does anyone have any ideas as I am quite stumped at the moment.

Thanks

Ada

--
soteman200
-----------------------------------------------------------------------
soteman2005's Profile: http://www.excelforum.com/member.php...fo&userid=2907
View this thread: http://www.excelforum.com/showthread.php?threadid=51822

Adding formulas based on range names
 

Hi Adam, ..........
I don't think anyone knows what you are trying to do? Could you be more
specific

"soteman2005" wrote:


Hi,

I have a workbook with three sheets(inputs, overrides, actuals) called
Demand I, Demand O and Demand A. Each row is range named between
columns J and T, with the same name on each sheet, with the exception
of the prefixes DCI, DCOV and DCA dependant upon sheet. I would like
to add a formula to every cell in Demand A column J that is a part of a
range name such that the formula is;

=if(and(DCO_overrides_enabled=TRUE,DCOV_blahblah< ""),DCOV_blahblah,DCI_blahblah)

where DCOV/DCI blahblah is the range name used on the current row.
Does anyone have any ideas as I am quite stumped at the moment.

Thanks

Adam


--
soteman2005
------------------------------------------------------------------------
soteman2005's Profile: http://www.excelforum.com/member.php...o&userid=29078
View this thread: http://www.excelforum.com/showthread...hreadid=518221