Home > Forum Home > Analyzing Corporate Financial Data > VALUE! Share

VALUE!

Excel Help for Value! in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Value!

Rate this:
(3/5 from 1 vote)
ConfusedI am doing calculations on a spread sheet and it has come up wiyth the error Value, I want it to be blank so when I add the column up is does it correctly.
I am trying to multiply 2 columns, one is a quantity and the is a result of an if  and lookup function. Do I multiply thje two columns or do I need to repeat how I got the calculations.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
To catch formula errors and return alternative values you can use the ISERROR function to catch any errors and replace the VALUE! with a blank or any other value such as zero.

Support your formula is A1/A2, then the formula would be:
=IF(ISERROR(A1/A2),"",A1/A2) 
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for VALUE! in the