#VALUE! Error

[keng11]

Hi,
Could I get some help eliminating this value error please.

AACalculator.xls
	A	B	C	D	E	F	G
1					365		#VALUE!
2	Return	Risk	Result	%	Year	Days	RORas%
Sheet1

Thank you for your assistance.

 

[MarkAndrews]

This should work

=IF(ISERROR(D1*E1/F1)=TRUE,"","D1*E1/F1")

 

[keng11]

Hi Mark,

Dosen't seem to do it I end up with D1*E1/F1 in the cell after all the other cells have their values in them.

Thanks.

 

[MarkAndrews]

Sorry type error, apologies

try this

=IF(ISERROR(D1*E1/F1)=TRUE,"",sum(D1*E1/F1))

 

[sam slade]

may i just ask,

do you add the '=TRUE' to the iserror so it is more readable?

Sam

 

[MarkAndrews]

may i just ask,

do you add the '=TRUE' to the iserror so it is more readable?

Sam

True defines the condition to the ISERROR

ISERROR - Is a question, "Is It Error" - therefore needs a logical answer (true/false)

HTH

Mark

 

[keng11]

Hi Guy's,
I am not as experienced as most of you with Excel just self tought.

 

[MarkAndrews]

Hi Guy's,
I am not as experienced as most of you with Excel just self tought.

As am I, over the past 8 years

Did my solution work for you?

 

[keng11]

Hi Mark,

try this

=IF(ISERROR(D1*E1/F1)=TRUE,"",sum(D1*E1/F1))

[/quote]


This code fixed the problem. Thanks for all your help.

 

[MarkAndrews]

No problem, Happy To Help