I have created a formula to look at cell f9 and depending on its value, I want to give it my own value. If its above 0 then it should always return with a '3'. If its under 0 then it should always return with a '0'. If the value is exactly 0 then it will return with a '1'. The issue I am having is that not all cells in row 9 have values. Therefore the formula returns a value of #value! where I also need this to return as a '0'. Here is the formula that works, I just need help with the final bit to change #value! to a '0'. My formula is =if(f9>0,"3",if(f9<0,"0",if(f9,0,"1")))
-
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.
=if formula showing #VALUE! as '0'
- Thread starter ronie85
- Start date
-
- Tags
- #value error =if
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Try somthing like...
=IF(ISNUMBER(F9),IF(F9=0,1,IF(F9>0,3,0)),"")
=IF(ISNUMBER(F9),IF(F9=0,1,IF(F9>0,3,0)),"")
Upvote
0
Hi
Sorry, this makes no sense to me. It doesn't matter if the cell in F9 has a value or not, you are just making comparisons and so the formula should never return an error value.
Remark: I'm assuming, of course, that the value in F9 is not itself an error value
Sorry, this makes no sense to me. It doesn't matter if the cell in F9 has a value or not, you are just making comparisons and so the formula should never return an error value.
Remark: I'm assuming, of course, that the value in F9 is not itself an error value
Upvote
0
Similar threads
- Solved
- Solved
