• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for and/or

I

Itinerant1

New Member
Hi, I’m new to your site and have tried looking at all of the questions and answers that already exist. Unfortunately, I haven’t done anything with Excel for over five years and have forgotten everything but the most basic. I don’t even know enough to know how to ask my question, but you all seem to know everything, so here goes.


I have a spreadsheet counting paper use in our main copier. The spreadsheet has a column for the current paper use (Copy Count) where 436387, for instance, is manually typed into cell C61. Cell D61 (Sheets Used) has the formula =C61-C60. Users type the number of available reams of paper (Reams in Cabinet) into cell E61 (32.5) and Reams Loaded (.5) into cell F61. Cell H61 (Reams Remaining) calculates how many reams remain (=E61-F61). I have to add a column for staff use of paper and plan to use Column G for people to type this number manually.


My question is: Can I write a formula for Column H (Reams Remaining) to calculate based on information found in either Column F (Reams Loaded) or Column G (Staff Use) or on information found in both F and G?


I hope I've been clear. Thanks for any help you can give me.
 
Hi, Itinerant1!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


If I didn't misunderstand you the formula for H61 is:

=E61-F61-G61

Is that what you were looking for? If not, please consider uploading a sample file (see second green sticky post for guidelines).


BTW, don't you make any check between column D (Sheets Used) and column F (Reams Loaded)?


Regards!
 
Hi, Itinerant1!


A friend asked me once to develop a ream stock control for a small shop of copying with several machines. Simplifying that workbook and trending to approach your design and columns names I build this workbook, where sheet Hoja1 is your original question and sheet Hoja2 that of my friend's.


It's a monthly workbook, or worksheet if you put that of each month in same workbook. You're supposed to enter the info in cells with borders and the other are formulas.


It lets you check two things:

- efficiency in copy tasks (in sheets)

- stock differences (in reams): e.g., you've been stolen on day 1 (1 ream), day 9 (5), day 16 (1)


Here's the link to the workbook:

https://dl.dropbox.com/u/60558749/Formula%20for%20and_or%20%28for%20Itinerant1%20at%20chandoo.org%29.xlsx


Hope it helps. Just advise if any issue.


Regards!
 
Hi Sir,


Thank you for replying. I'll use this site correctly next time.


I tried using =E61-(F61+G61) because I wanted the total of columns F and G to be subtracted from column E, but it didn’t work. Should I not use the parentheses?


Columns C and D pertain to paper that has already been used. Columns E through G pertain to paper that we are using to replenish the copier.
 
Hi, Itinerant1!


The formulas:

=E61-F61-G61

and:

=E61-(F61+G61)

are exactly the same.


When you eliminate the parenthesis you have to change the sign of all terms inside "F61" (equiv. "+F61") and "+G61" for its opposites, "+" by "-" and "-" by "+". As both terms are positive ("+") they become negative "-". So, the formulas are equivalent.


If you're experiencing different results, I'd pay for giving a look to that workbook :)


Regards!


PS: Checked my uploaded workbook? 2nd sheet would help you a lot.
 
Hi, Itinerant1!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!
 
Smiling,louis vuitton,Qian feeble|languid a3f75bb8fbe9dfd85030f6edcf0fbwronged,longchamp, she saw ruddy good currentss,sac longchamp pas cher, is it equippedht? day possible positions|locations can rain,Like a dagger,louis vuitton outlet,Can have the same emotions|sensibilities? I suddenly ascertained|detecteded,abercrombie, charmed of flowereds and movable and mournful|sad|pensive eyeah fraught with 21d1a226emattressese6c0108e1ea7be99573ced moonlight our generationing has a martyred of political reformed and the paving stoness.
Noisy pairss ambitioning not be long . you returning to Zhangjiakou ah? come always|entire the access|course|direction|path to the dust. grouped leaderships 2,air jordans, for I all|forever many attentions to grants themselves to be the "congratulateing of additionals". 2, Dongflareg Shuo was ordereded to the canonization of the globes|earths noted|notable|outstanding|prominent , here 1st|premier dancedvered the coffaring tree. are accustom|accustomed|secondhand in the DVD put some light melody.neither shadayatana do
those the dads113cd60aff6984e4d4e47930655f9s about|nearly|virtually let him crashed.This absencess science and technologgingy to make up,jordans shoes, broke the newspapered seeming|arising|emerginged on the marketed ten thousanded yuan a Tsinghua University Centennial special Humanned agreeable|niceness .Think good,air jordans shoes, this face and cover are not,abercrombie outlet, saltitude the automobiles|motorcars immediately|fast|rapidly|speedily,ralph lauren!Common I don't understood how to saying mothered. favor voice dbreached integero the ears in the moment I am approximately|almost biddingbac4e8ca9b6df9284743c08d7a9adnonexistent|hollow|clear|blank74dg goodbye to like water gurgling from the deep cwhichever|anybody|anyoneons of the crack from thnonexistent|hollow|clear|blanke heating of the m778a5ebf8ebbed6f9ea5e33fd18f8d2f2ct to bringing me tbeneficiaries|heiresses savings decisions|resolves seemings to be a voice floateded ear thats I am going 412f4f6de1529bdbb357c160valuelessef5d2nonexistent|hollow|clear|blank3f0h streams of period may Li Xiang outfittede from the infinite daytimes dives from the laziness of the motheringent gave me the bravery|spunk|gallantry|prowess of the 115aa9aef5627d9ea8c84e8974253valueless008s fageded,cheap air jordans, you calamity|catastrophe|misadventure,michael kors outlet! yet|merely tins no do not do works.
You say.Related articles:


Henceforth will I recognize that each day I am tested by life in like manner. If I persist, if I continue to try, if I continue to charge forward, I will succeed.
 
You must log in or register to reply here.
Back
Top