Formula:
=IF(ISBLANK(V6),IF(ISBLANK(Q3),"",1),1)
I have this formula which I am going to have to nest much more IF and ISBLANK formulas into. What I would like is if any of my cells (right now just V6 and Q3) contain a number value, then the number 1 is shown. Right now both cells have to have a number in it in order to display 1. What am I doing wrong?
Perhaps =IF(sum(V6,Q3),1,"")
Thank you, it worked and is way easier. I just did it with 13 cell references in a minute or so, I would have hated to typed out that many references with the way I was trying to do it.
=if(sum(v6,q6)>0,1,"")
edit: is there an echo in here Pepe...Pep...P....
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You're formula works as expected for me.
If Either cell (V6 or Q3) contain a number value (or any value really, just not blank)
Then the formula returns 1.
Only if BOTH cells are blank, does it return the ""
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks