Hello,
Im new around here, Im trying to make a formula that if A1 has a value between 1 and 300 then B2 equals 190, but so far is not working. I have office 2013.
This is what I have done
=IF((AND(A1>=1,A1<=300)),190)
Thannks!
Hello,
Im new around here, Im trying to make a formula that if A1 has a value between 1 and 300 then B2 equals 190, but so far is not working. I have office 2013.
This is what I have done
=IF((AND(A1>=1,A1<=300)),190)
Thannks!
Hi & welcome to the board
TryFormula:Please Login or Register to view this content.
You are missing the false action of the statement.
What do you want B2 to equal if the result of the And statement is false.
The syntax is =If(criteria, true action, false action)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks, That was fast. But dosenīt work
Thanks, But didnt work
Didn't work does not help us to help you. What do you want B2 to be if the result is false. Perhaps you need to provide a sample workbook with a before and after scenario mocked up.
In what way doesn't it work?
I agree with Alan above.
You could also do a formula like:
=IF(AND(A1>=1,A1<=300),190,"")
Which would give a blank instead of zero.
There is a chance that the stuff in A1 looks like a number but is really text . Then perhaps this would work for you.
=IF(AND(VALUE(A1)>=1,VALUE(A1)<=300),190,0)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
If B2 is false it could show 0
could you answer my question in post#7
Are you sure that A1 does actually contain a number/value and not text that looks like a number?
Test with =isnumber(A1)...false indicates text and we will need to convert it
Aslo, an answer to some of the previously asked questions, would help, too
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks