=IF(ISERROR) doesn't work

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

I have three conditional formats on a cell:

1. Cell value is less than 0 (it works)
2. Formula is =(B10="") (it works)
3. Formula is =IF(ISERROR) (doesn't work)

I've tried various combinations to get number 3 to work -
can someone suggest a fix?

Thanks,
Phil
 
Phil,

Try

=ISERROR(B10)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Excel IF ISERROR formula to VBA 1
averages with formulas 5
Excel VBA 1
converting a for next loop into a for each loop 2
Converting a formula into an if function 0
Nested If Function to be converted into a user-defined customfunction 1
Macro autofills formula when a cell value is changed 4
Conditional Formatting 4

Back
Top