I have spreadsheet with two rows, and cells lets call them A1 and A2. I want results or formula in A3 to be this way. If A2 is greater than 0 then what ever number in A2 should populated in A3, but if A2 is 0 then what ever number in A1 should be populated in A3.
Thank you
maybe...
=if(A2>0,A2,A3)
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
Thank you for the quick help. It worked.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks