OR using 2 cells...

[timberdog]

Hi
I guess you can tell by my (possibly inccorectly worded) question I am recently new to excel. I know a bit but am trying to create a sheet that calculates print paper prices (I do large format printing). I have the basic calculations in place but I need to be able to use the contents (variable) of 2 cells (paper dimensions) to see if I have that paper in stock. i.e if both of the dimensions exceed my paper width I need to return 'false' otherwise 'true' (or 'paper in stock' and 'paper out of stock', either way). It would also be nice to apply a cell colour to both results.
i have tried =IF(OR(D2>0,D2<910),"Yes","No") where 910 is max width of paper in stock and =IF(OR(D2>0,D2<910)),"in stock","out of stock") but to no avail. I realised that labling the paper dimensions 'long side' and 'short side' would help but I'd rather be able to incorperate both boxes to get my result!
I hope this question is clear enough for someone to help me !

thank you (anyone) in advance !
timberdog

 

[Joe4]

Welcome to the Board!

I am afraid that your questions may not be quite clear. You mention two cells, but I actually see you using one single cell twice (D2).

Can you try explaining again, maybe providing an example of what is in these cells(s) and what your expected outcome for that example is?

Also, bear in mind that with OR, only one of the conditions has to be met to return TRUE. If both need to me met, you want to use AND instead of OR (I can't tell if that is what you want to do or not, but thought I would mention that).

 

[timberdog]

Thank you very much Joe4
I had been at it all day and couldnt formulate my question properly - sometimes its really hard to explain what you want to get, its more of a 'feeling' if that makes any sense!!! The 'AND' formula was of course correct and now have that bit sorted.
Im sure that I have more to do on this sheet, let alone desiging a work book for my finances - I will be requesting help once again I'm sure.
Much appreciated
Timberdog