Hi! (:
How do I create a formula such that
If cell B27 is NOT 0, cell B11 takes the value of B27
If cell B27 is 0, cell B11 takes the value of B28
If cell B28 is 0, cell B11 takes the value of B29
And so and so forth.
How do I do that?? I do not want to create a VBA because I do not know how to.
Thank you.
If(abs(b27)>0,b27,if(abs(b27)=0,b28,if(b28=0,b9)))
☚ Click ★ just below left if it helps, Boo?ath?
{=INDEX($b$27:$b$100,SMALL(IF($b$27:$b$100<>0,ROW($b$27:$b$100)-ROW($b$27)+1),1))}
Try this array (Press Ctrl + Shift + Enter) formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You may try this regular formula....
Is this what you are trying to achieve?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks