formula fill down

P

Pezcore

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

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

Eric

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.
 
P

Pete_UK

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

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

Hope this helps.

Pete
 
P

Pezcore

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

Gord Dibben

=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
 
Top