Hello, I'm looking for help setting up my inventory spreadsheet.
I would like to have a value in cell A (my item inventory total) compared to a value in cell B (my par level for ordering). I would like to have to show in cell C "YES" if the value in cell A is less than cell B and "NO" if this isn't the case. Any help is greatly appreciated!
Toris
welcome to the forum. does this help you?
=IF(A1<B1,"YES","NO")
otherwise, do upload an excel sample so that we do not have to manually key in your data to do a testing.
input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.
the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.
if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I'll plug it in and see! Thanks for the quick response, i'll be sure to get back to this in a moment.
~Toris
Yes that was perfect! Thanks so much! I have a feeling I'll be on here a few more times before I'm all set, so thanks for the warm welcome.
A followup? Is there any way to change the format of the yes or no value? ie: green and red color fonts?
you're very welcome. that should go to a new thread. but you can consider conditional formatting for that. select the range you want to apply to (say from A1:C10)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$C1="Yes"
Format a fill color you desire.
repeat the steps for "No". formula:
=$C1="No"
or if you wish to simply highlight column C, it's easier. select the range you want to apply to (say from C1:C10). Home Tab -> Highlight cell Rules -> Equal to -> Yes
format a color fill desired.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks