#VALUE! Error

keng11

New Member
Joined
Aug 11, 2006
Messages
16
Hi,
Could I get some help eliminating this value error please.
AACalculator.xls
ABCDEFG
1  365#VALUE!
2ReturnRiskResult%YearDaysRORas%
Sheet1


Thank you for your assistance.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

keng11

New Member
Joined
Aug 11, 2006
Messages
16
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

Well-known Member
Joined
May 2, 2006
Messages
1,963
Sorry type error, apologies

try this

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

sam slade

New Member
Joined
Sep 14, 2006
Messages
22

ADVERTISEMENT

may i just ask,

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

Sam
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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

New Member
Joined
Aug 11, 2006
Messages
16

ADVERTISEMENT

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

keng11

New Member
Joined
Aug 11, 2006
Messages
16
Hi Mark,

try this

Code:
=IF(ISERROR(D1*E1/F1)=TRUE,"",sum(D1*E1/F1))
[/quote]


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

Forum statistics

Threads
1,136,594
Messages
5,676,700
Members
419,644
Latest member
KeelsM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top