=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+R4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?

Change the address reference to absolute in the formula--a dollar sign in
front of the column letter, row number, or both, depending on which element
of the cell address you want to remain constant.

Same principle for filling right, as well.


"Pezcore" wrote:

=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+R4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?

You use absolute addressing, like $R$4 instead of R4, so your formula
might become:

=IF(DataInput!D3="Standard",$R$4*119.25%,IF(DataIn put!D3="Recommended",
$R$4*(1+$Q$4),0))

Hope this helps.

Pete

On May 10, 1:43*am, Pezcore wrote:
=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+R*4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?

=IF(DataInput!$D$3="Standard",R4+R4*19.25%,IF(Data Input!$D$3="Recommended",R4+R4*(1+$Q$4),0))
i would like to know how i add an error checking function to this formula?

"Pete_UK" wrote:

You use absolute addressing, like $R$4 instead of R4, so your formula
might become:

=IF(DataInput!D3="Standard",$R$4*119.25%,IF(DataIn put!D3="Recommended",
$R$4*(1+$Q$4),0))

Hope this helps.

Pete

On May 10, 1:43 am, Pezcore wrote:
=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+RÂ*4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?

=IF(ISERROR(IF(DataInput!$D$3="Standard",R4+R4*19. 25%,IF(DataInput!$D$3="Recommended",R4+R4*(1+$Q$4) ,0))),"",IF(DataInput!$D$3="Standard",R4+R4*19.25% ,IF(DataInput!$D$3="Recommended",R4+R4*(1+$Q$4),0) ))


Gord Dibben MS Excel MVP


On Sat, 10 May 2008 04:30:00 -0700, Pezcore
wrote:

=IF(DataInput!$D$3="Standard",R4+R4*19.25%,IF(Dat aInput!$D$3="Recommended",R4+R4*(1+$Q$4),0))
i would like to know how i add an error checking function to this formula?

"Pete_UK" wrote:

You use absolute addressing, like $R$4 instead of R4, so your formula
might become:

=IF(DataInput!D3="Standard",$R$4*119.25%,IF(DataIn put!D3="Recommended",
$R$4*(1+$Q$4),0))

Hope this helps.

Pete

On May 10, 1:43 am, Pezcore wrote:
=IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataIn put!D3="Recommended",R4+R*4*Q4,0))

how do i reference a cell in a formula and not have it change all down the
columns?