# #VALUE! Error

#### keng11

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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
This should work

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

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.

Sorry type error, apologies

try this

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

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

Sam

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

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

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?

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.

No problem, Happy To Help

Replies
1
Views
394
Replies
3
Views
344
Replies
7
Views
153
Replies
6
Views
122
Replies
4
Views
196

1,219,006
Messages
6,145,711
Members
450,635
Latest member
Rookie3510

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

### Which adblocker are you using?

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

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