Check cell for value, if match then "number", If no match then show actual value in cell
Hi,
On our store product upload spreadsheet we need to reflect "product quantity" that shows on our distributors export file, we currently use the distributors spreadsheet as our database to create the file needed for our store import.
I need help with a formula that checks a cell for a value then returns a value.
The values we need are to match ">5" and return "5" but if no match then return the actual value of that cell whether it be 1,2,3 or 4.
Thanks
Try this
=if(a1>5,5,a1)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Hi
Do you mean?
=if(a1>5,5,a1)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Or
=MIN(A1,5)
If the number in "Sheet1 L2" matches with the number "Sheet2 C5" the formula should write the number in "Sheet2 G5", or
If the number in "Sheet1 L10" matches with the number "Sheet2 C40" the formula should write the number in "Sheet2 G40", or
If the number in "Sheet1 L15" matches with the number "Sheet2 C50" the formula should write the number in "Sheet2 G50".
M_KANIK...
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks