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
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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
