Solved

Is Error blank

Posted on 2011-03-14
3
243 Views
Last Modified: 2012-05-11
Hi,

I have a formula where  if there is a value error i would like the cell to be blank

formula = I3-F2

So i need an iserror or something like that>?

Thanks
Seamus
0
Comment
Question by:Seamus2626
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35127579
You can use something like this:

=IF(ISERR(I3-F2),"",I3-F2)

jppinto
0
 

Author Closing Comment

by:Seamus2626
ID: 35127586
Thanks Jppinto!

Seamus
0
 
LVL 33

Expert Comment

by:jppinto
ID: 35127590
This will show the value of the formula (I3-F2) if there isn't any error; if there is an error, it will show blank:

=IF(ISERR(I3-F2),"",I3-F2)

This will just check for an error and if there is an error it will show blank:

=IFERROR(I3-F2,"")

jppinto

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question