The formula I am looking for is
If D1= between 1000 and 1999 then E1 = 5 any other number in D1 would result in E1 = 7
The formula I am looking for is
If D1= between 1000 and 1999 then E1 = 5 any other number in D1 would result in E1 = 7
maybe this...
=IF(and(D1>-1000,D1<2000),5,7)
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
That's great Thank-you
Happy to help
I just noticed a small error (a typo actually) in my formula...
=IF(and(D1>-1000,D1<2000),5,7)
should be...
=IF(and(D1>=1000,D1<2000),5,7)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks