Ms Excel

[Lestat]

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

Is this a test or homework of some sort?

 

[Lestat]

thanks to everyone who gave me K for this thread!! good bro material

 

[Cutiebaby]

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.

 

[Lestat]

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.

 

[Cutiebaby]

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.

 

[Cutiebaby]

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

 

[Cutiebaby]

Hello

 

[redguru]

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

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.

 

[Cutiebaby]

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]

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

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.