Hi
I am trying to give a score if below or above 0.
1 if below
2 if above
If less than 0=1,if more than 0=2
Hi
I am trying to give a score if below or above 0.
1 if below
2 if above
If less than 0=1,if more than 0=2
What if equal to 0?
Assuming your value is in A1, then try this.....
Does this help?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.
Perfect Thank You
You're welcome. Glad it helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks