Hello group -
I have one column that contains an If statement formula and would like the next column to then work off of the first column (i.e. if that 1st column returns a value then then adjacent column uses that result).
What is happening now is that it is returning #value (because I guess technically the cell isn't blank?)
Anyone have a workaround?
Thanks
Hard to say without seeing your worksheet or your formulas. Taking out my crystal ball.......
Try =IF(A2<>"", Result you want, "")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Can you post the formula?
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
First Cell:
=IF(N20>0,N20/$B$3," ")
Adjacent cell
=IF(ISBLANK(L20)," ",M19+L20)
B3 is simply a dollar value so I am having the first cell calcualte a percentage
Assuming the first cell is L20, then it is not blank.
Even "" is not considered a blank and " " is even less of a blank (if that's possible) because it's a space.
I suggest, first cell
=IF(N20>0,N20/$B$3,"")
second cell
=IF(L20<>"",M19+L20,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks