Ms Excel

[chris302001]

before my time.... fuggin fogies in here.....

 

[EnderJE]

Look up the function IF (logical value or test condition, value if true, value if false).

 

[PICK3]

Let's see ...

There's 4 bushels in a peck

 

[Cutiebaby]

Look up the function IF (logical value or test condition, value if true, value if false).

have but for some reason it will not work for me?

 

[EnderJE]

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]

post up the formula you're using that is getting the error

 

[PICK3]

post up the formula you're using that is getting the error

^^^
got smarts real good

 

[Cutiebaby]

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]

ololol! @ Angel P'WNED by a spreadsheet

 

[Cutiebaby]

better than being pwned by my own avatar!