Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Try:
=IF(E6,(E6-F6)/E6,"")
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#DIV/0! Error
- Thread starter Aladin Akyurek
- Start date
Try:
=IF(E6,(E6-F6)/E6,"")
Excel Facts
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
In case you didn't see any reply...
Upvote
0
Jay Petrulis
MrExcel MVP
- Joined
- Mar 17, 2002
- Messages
- 2,040
Hi,
Aladin already provide the solution, but the reason you are receiving a #DIV/0! error is because your test condition is comparing the result of a calculation with a string, not a number. So, the FALSE condition occurs and you return a result that divides by zero.
Aladin's formula is much nicer, but you can achieve the same thing you want by removing the quotes around the zero.
Bye,
Jay
Upvote
0
