testing cell value

  • Thread starter Thompson, Joseph
  • Start date
T

Thompson, Joseph

requirement ... test each cell for negative value. if true, b1=value of
previous cell
sample:
A B
1 10 5
2 5
3 -1

thank you.
 
G

Grey Newt

I'm probably not alone by being a little confused !
Do you want a VBA or a formula solution - could be done with either?
"Test each cell for negative value" - the cells in column A I presume. Correct?
"if true, b1=value of previous cell" - I presume because A3 is negative, and 5 is the number above it, B1 now=5. Correct?
What if there is more than one negative value in column A - or no negative value?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Finding the right style field in VBA 0
Word macro that can call cells out of Excel for a find and replace 0
Finding the proper style field and the numbered paragraph value within the style 0
Drop down list control value in vba 2
A data validation question 1
Arrays and scattered cell values or another way? 16
writing a value to a particular cell from function 3

Top