Combination If Error formula result

jlr123

New Member
Joined
Mar 6, 2014
Messages
25
I need a combination formula for If error and if result of formula =0. Formula I have now for if error is the following:
=IFERROR((I2-J2)/J2,1) however if cell I2=0 and J2 =0, I would like the result to be 0.

Thanks for your assistance. I know this has to be something simple.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

theBardd

Rules violation
Joined
Jan 21, 2012
Messages
912
Just add that test first

=IF(AND(I2=0,J2=0),0,IFERROR((I2-J2)/J2,1))
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,556
Messages
5,415,257
Members
403,573
Latest member
stdar2

This Week's Hot Topics

Top