Good afternoon, I have attached a file which has a formula to pick up text, I need to add an "If" statement to separate the numbers with a value greater than zero in one column and in the other column return the numbers with a value of less than zero. Any assistance would be greatly appreciated.
Last edited by Steve2107; 07-27-2016 at 01:53 AM.
Perhaps Try
H2=IF(AND($E2>0,$F2="Housie"),$E2,0) and drag down.
J2=IF(AND($E2<0,$F2="Housie"),$E2,0) and drag down.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you so much Ankur, I got so hung up on the ISNUMBER formula,that I could not think of anything else, this is just brilliant, well done mate.
Steve.
Steve thanks for feedback, Request you to please add reputation by clicking * star icon on your left corner screen of thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks