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