Please Scroll Down to See Forums Below
Ms Excel
- Thread starter Cutiebaby
- Start date
Oh I am but after your joke the other day I don't know???
bigmann245
New member
sure what do you need to know??
Oh I thought noone would respond..I am super bitch ready to kill the family and on the verge of tears, I cannot figure this the fuck out and it is pissing me off..
It is all about the functions...I need to get a function that will return a “Y” if the amount on hand (45)is less than half the minimum order amount and an “N” if the amount on hand(45) is more than half the minimum order amount. With the minimum order is 45.
kthanx
It is all about the functions...I need to get a function that will return a “Y” if the amount on hand (45)is less than half the minimum order amount and an “N” if the amount on hand(45) is more than half the minimum order amount. With the minimum order is 45.
kthanx
fuck i dont know what that means
I'm pretty familiar.
What is it about functions that you need to know?
What is it about functions that you need to know?
conjunction junction what's your function?
great song
chris302001
Banned
before my time.... fuggin fogies in here.....
have but for some reason it will not work for me?
If there's an error message, then it's got to be your syntax.
I can't really help much without looking at the problem. I'm not sure how much help you're going to get on here with all these people.
chewyxrage
New member
post up the formula you're using that is getting the error
PICK3
New member
If there's an error message, then it's got to be your syntax.
I can't really help much without looking at the problem. I'm not sure how much help you're going to get on here with all these people.
Ok so I have an excel chart that has various shit on it.
I have the on hand as being 45, then the minimum order as 45, however obviously the min order changes on the chart which is fine because auto fill will change that after the fact. Any ways
So I have to make a function that will return a “Y” if the amount on hand is less than half the minimum order amount and an “N” if the amount on hand is more than half the minimum order amount.
So I have done almost every function excel has and even managed to probably use functions that don't exist. Been onto this for many hours and pissy as all get out....
I dont get the shit. Why is not returning Y and N? Excel is stupid
PICK3
New member
Razorguns
Well-known member
OMG u dodohead. Excel is easy.
sheesh here:
An If Statement is used in Excel to do certain actions only if something is true. For example, you might want to print out the message "We are losing money" if total sales for the quarter are below some amount. Otherwise, you'd just want to print out "We're making money!"
MS Excel Tutorial - If Statement
PICK3
New member
pick3 = p'wned!!!
Thank God for Visual Basic.
Its much easier if you show a sample of your data, preferably in columns, and state your business logic clearly. Use different numbers when talking through examples with two diffent values. In your case you said the minimum amount was 45 and the amount on hand (assuming that is the current order amount?) was 45 as well, but then said you wanted to compare to half of the minimum order, so why not just start there? (22.5?)
something like this?
Holy shit Lestat this is perfect..Only one thing is that each row the minimum order and on hand orders change. They do not stay at 45. So do I use the cell for instance C4 instead of saying 45?
I will try to post spread sheet.
Yes, in my forumula I did not hard code any values, they are all relative, so it will compare whatever values you populate in the columns.
This is what I have to do next
Orders are placed if the amount on hand is less than half the minimum order amount. Use a function in cell B5 to return a “Y” if the amount on hand is less than half the minimum order amount and an “N” if the amount on hand is more than half the minimum order amount.
Orders are placed if the amount on hand is less than half the minimum order amount. Use a function in cell B5 to return a “Y” if the amount on hand is less than half the minimum order amount and an “N” if the amount on hand is more than half the minimum order amount.
Lestat thank you.......I got it to display by using =if(c5<d5/2,"y","n")
but now i need to
10. The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
but now i need to
10. The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
Done.
See the formula?
=IF(C5<(D5/2),"Y","N")
Where column C is the amount of on and column D is the minimum order amount.
Done.
See the formula?
=IF(C5<(D5/2),"Y","N")
Where column C is the amount of on and column D is the minimum order amount.
see post #36
Razorguns
Well-known member
Is this a test or homework of some sort?
Fackin stupid homework!!!
Thank you so much, I appreciate the help...I am pro at word and semi good at power point but excel has always been my weak spot...I am off to try to continue working on it..Thankfully it is not due right away so I have a few nights to mess with it.
yeah, I was gonna say, if this is for a class, then its better to spend the time to figure it out for yourself, you'll not only learn the functions, but also some problem solving skills, both of which will pay off when it comes to practical application of these concepts.
Good luck with it, let me know if you need any additional help.
See I have issues when it comes to school work, I like it done yesterday even if it is due in 2 weeks, lol. So I freak out and rip my hair out, even cry if I cannot do it when i want it done by..So I am taking it slow now, even opened the dang book, HAHA. Now using the help button too!
I'll let u know if I need anything else...thanks bro.
HELP!!!!!
I have tried
formula If and also other forumlas and nothing is working the way it should..
I need to -The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
I have gotten everything else but that and this along with an exam needs to be completed in 3 days along with a midterm for gov class, and exam in math, and also a fucking essay and exam in crj...I just need 1 more push....Thanks
I have tried
formula If and also other forumlas and nothing is working the way it should..
I need to -The order amount column needs to reflect the amount in the minimum order column only if the corresponding Order Y/N entry in column B is Y. Use a function in cell C5 to return an “NA” if an order should not be placed and the minimum order amount from column D if an order should be placed
I have gotten everything else but that and this along with an exam needs to be completed in 3 days along with a midterm for gov class, and exam in math, and also a fucking essay and exam in crj...I just need 1 more push....Thanks
redguru
New member
Since there is no Order Amount column it looks like you need to insert a row at C then you can use an IF( function in the corresponding cells. If you didn't use a $ to lock the used cells in your previous formulas, excel will automatically update the cell references. If(B5=Y,E5,"N/A"). You can't use text in a function without quotation marks around the text, otherwise excel will think it's a cell reference.
So just insert an empty row at C? Do not add any text to it? I under stand i need to " and " around the NA I got the error message LOL, I also see that I cannot use the same cell reference twice as I was doing
IF=D5>C5,D5,"NA") and it was coming back talking about using same cell twice. Lol i hate this crap...Hate it Hate it Hate it..But i need to do it today as it is due and I also have the exam due as well....Ugh
redguru
New member
Sorry, not row, column. right click on column C and insert column
then you can put your function in row c. ALL functions that used the previous column c and higher will auto-update.
I knew what you meant..Not going across, but going down..Cause going across is numeric. I think I may be able to figure it out..We shall see...
Similar threads
