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
Thanks in Advance
What error do you get?Originally Posted by nstcctv
Don't quote numbers:
=IF(A17>=25,24.95,34.95)
Quoting numbers turns them into TEXT strings!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Disregard. I tried data validation first and did not clear the data before trying as a formula.
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.
Data validation can only be used for determining whether Excel will accept an entry, it can't modify an entry.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks