Hi All,
I need a formula for the following example
Column A contains a quantity. Column B shows a 0 until we come to a number. I'd like a formula in column C that says -
"If B1=0 then display the figure in A1. If B1=a new number, show that number in C1."
I've attached a workbook.
Can anyone help?
Never mind, not what the OP wanted
Last edited by gmr4evr1; 06-18-2015 at 09:15 AM. Reason: Removed post
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Think I got it now
Going by your sample, place one of the following codes in C2, they will give the same results.
Or
Please Login or Register to view this content.
Please Login or Register to view this content.
As simple as that!
thank you!
You are welcome, glad it worked for you. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks