=IF(AND(N5>4999,N5<6000),"BUSINESS","PERSONAL")
The statement should read as follows:
If the value in N5 is between 5000 and 5999, return the value ** Business, otherwise return the value ** Personal.
This functional statement does not work. Why?
Thanks for your help
Deleted duplicate post.......
Last edited by martindwilson; 03-08-2014 at 07:06 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
works fine for me but you can use >=
=IF(AND(N5>=5000,N5<=5999),"BUSINESS","PERSONAL")
but the way you have it it would give BUSINESS FOR 4999.1
Do you have an actual value in N5? Test with =isnumber(N5) False indicates text
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
Or you can enclose the value() function to the cells which contains the numbers... Like so:
Value() will be able to convert the text string which contain a number into the number format.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks