hiding formula error #DIV/0!

[noot]

Hithere,

In a sheet, for a cell I use the formula:
=(F4/1,19-D4)/(F4/1,19)

If there is no input yet in cells F4 or D4 an error message "#DIV/0!" is
shown.
I don't want this message visable when there is no input yet in F4 and D4.

The solution I found Googling was to use
=IF(ISERROR(OriginalFormula),"",OriginalFormula)

Translating that to my formula, I came up with:
=IF(ISERROR((F4/1,19-D4)/(F4/1,19)),"",(F4/1,19-D4)/(F4/1,19))

Inserting this formula however makes Excel complaining that there is an
error in this formula, specificly pointing to the ,"", part in the middle.
I have no clue what I'm doing wrong.

Any help for this Excel-newbie?

t.i.a. Noot

 

[mrice]

Are you sure that the commas between the 1 and the 19 should be there?

Is your number format set to recognise commas as a decimal point?

 

[noot]

Yep, we're Dutch ;-)

 

[Bernard Liengme]

Assuming 1,19 is 1 19/100 (i.e the comma is used for the decimal symbol)
Why not simply the formula to =1-1,19*D4/F4
This can give an error only when F4 is zero (an empty cell is treated as
zero)
So =IF(F4<>0, 1-1,19*D4/F4,"")
The last part is a pair (2) double quotes (")
Now, we North Americans are only vaguely aware of other people's
conventions. Do you normally use ; to separate arguments in a formula?
IF so use =IF(F4<>0; 1-1,19*D4/F4;"")
best wishes - let us know if all goes well

 

[noot]

Wow, I'm very impressed, you were right twice

Working like a charm now.

Thanx!

 

[Bob Phillips]

That formula would not give #DIV/0 whether there is anything in D4 and/or
F4 or not. #DIV/0 occurs when the divisor is 0, and it is 1.19 in your case.

Something else must be afoot.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)