I am using a spreadsheet to keep track of data for a group of gamers.
Which depending on the week can have anywhere from from 100 - 400 rows added.
I am trying to figure out a formula to use that will subtract cell I from N if there is a number in I over 10000 if not subtract L from N and put the answer into S.
I have been using "=N82-L82" but typing it out for each new row with the acording number.
Any help would be greatly appreciated.
can you try this out
=if(I >=10000,N-I,N-L)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you for the responce, though all it is giving is #Name?
try this...
=if(I>10000,N-I,N-L)
add the row numbers to suite
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thats what I was trying to avoid is having to put in the row number for each one.
Try this:
-Click on a cell which has the formula you want to copy
-Hover over the lower right hand corner to see the cursor change into a cross
-When you see the cross, click, and drag down the number of cells you wish to put the formula into
As long as the formula is populated correctly in the first cell, it will populate correctly into the rest.
you don't have to put the the rownumber in for each row, put the first in the first cell, select the cell, put the cursor on the bottom right corner of the cell (it will be in right spot when you see the '+' sign as cursor,NOT the regular cell select plus sign, click and hold, then 'drag' the formula to the end of your column/row..
the only real problem with this is you have to make sure of your absolute, and relative addressing, some rows may need to be ALWAYS used, or some columns may ALWAYS need to be used (that's what the "$" character is for )
Last edited by dredwolf; 12-02-2012 at 11:55 PM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thank you, dragging the + down was what I was looking for. Thanks for everyones input and help in this.
You are welcome
Don't forget to mark the thread solved if you are happy with the results,(top of page, thread tools, mark as solved)
happy to help, and thanlks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks