#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

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")
 
Upvote 0
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.
 
Upvote 0
Sorry type error, apologies

try this

Code:
=IF(ISERROR(D1*E1/F1)=TRUE,"",sum(D1*E1/F1))
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
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.
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
Back
Top