# IF greater or equal then formula without using data validation

1. ## IF greater or equal then formula without using data validation

I am trying to create a simple formula without using a data validation list.

1. Is it possible
2. If NOT how do you create in data validation

I have tried this formula inside and outside of data validation, Googled till my fingers bled and can't find what I am looking for.

A17= Number 1 or higher
Statement tried but receive an error

=IF(A17>=25,"24.95","34.95")

My goal is IF A = 25 or greater then price is 24.95, If False then 34.95  Register To Reply

2. ## Re: IF greater or equal then formula without using data validation Originally Posted by nstcctv A17= Number 1 or higher
Statement tried but receive an error

=IF(A17>=25,"24.95","34.95")
What error do you get?

Don't quote numbers:

=IF(A17>=25,24.95,34.95)

Quoting numbers turns them into TEXT strings!   Register To Reply

3. ## Re: IF greater or equal then formula without using data validation

Disregard. I tried data validation first and did not clear the data before trying as a formula.  Register To Reply

4. ## Re: IF greater or equal then formula without using data validation

Hi,

You can't have a formula in a cell and also expect that cell to end up with a value that's determined by whatever formula is in that cell. The cell can only contain either a constant value or a formula. You could use a helper cell other than A17 with a formula to evaluate A17. Otherwise you would need a macro. e.g. ``Please Login or Register  to view this content.``
Data validation can only be used for determining whether Excel will accept an entry, it can't modify an entry.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 