Search the Community
Showing results for tags 'cells'.
Found 7 results
-
Just in general for any battery if a battery has multiple cells and is ran in a series does the battery drain 1 cell at a time? If the battery is ran in parallel does all cells drain at the same time?
-
I'll try to explain what I'm trying to do....more for fun than any real need. I'm doing a book keeping spreadsheet. On a summary page, I have a formula that adds the numbers in a column based on the "code" found in the next cell. This helps me to track different sources of income, each one with it's own code =SUMIF(A4:A85,U93,E4:E85) so this formula says to compare the letter code found the cells A4 to A85 and IF they are the same as the comparison cell (U93) then return the SUM of the value from cells E4 to E85. This formual is repeated IN DIFFERENT CELLS with different comparison cell codes. (U94, or U95) I want create a similar formula to read a name found anywhere in a range of cells and if it is there, to then print that name in another cell. (on the summary page) yet, not have other cells repeat that name ....AND.... if that name is not in that range of cells, to allow a different name to be returned in that same cell I can't use the same formula because I am asking for text...not numbers. in much the same manner, I can look at the range of cells, and return a number associated with that company name =SUMIF(B11:B89,"Hydro One",J11:J89) ...asking it to give me the SUM of payouts found in cells J11 to J89, as long as "Hydro One" is contained somewhere in the range of cells from B11 to B89 This formula works fine when I ask it to look at a single cell. =IF(B11=R101,"company name","") so in the cell on the summary page... the formula looks to see if cell B:11 contains the same name as the comparison cell (R101), if it does, it displays "Company name", if that exact name is not found , it displays nothing ("") When I ask it to look at a range of cells it returns the "false" value ("") because that specific text is not in every cell of the range. I THOUGHT it would check the entire range of cells to see if that name is in ANY of the cells....but it is actually checking ot ensure the name is in ALL of the cells =IF(B11:B85=R101,"company name","") What formula can I use to get it to check a range of cells, and return a name from a multiple choice of 5 companies. Of course if any name is already used in that cell then it has to just forget about the whole thing and move on. The next cell below would do the same until all the vendors are listed along with their totals. Any suggestions...perhaps a macro? I could just type in in...but what's the fun in that?
-
Well guys I just got back from the doctor and the ct scan was clear. I am cancer free. They are going to do radiation treatments to make sure they got all the cells but looks like I will live to ride again. Thank you for your prayers.. Curtis
-
Just wanted to let you know the we made it home safe!! Put on 2011 miles (which I know is just a short run for some of you!) through the Black Hills and just want to say thanks for all the input on the different roads to take! It was beautiful!! The best part of the trip was when each one of our boys came and told us it was the "best trip they've ever had"! No cells, no tv's and no crowds. It's the perfect time of year to go out there! Hubby had a lot of lookers & questions on his new carrier he built! It worked great! Trying to catch up on the forums and just wanted to say it's been fun catching up on all the humor you clowns throw at each other!!
-
That last accident sure cluttered your brain cells Brad ...A Honda :rotfl::rotfl:Im sure your toes wont reach the pavement:rotfl::rotfl:
-
Over the years I have let x amount of batteries go bad by leaving them hooked up but not riding enough. This last new battery I bought was to be different in that I bought a Battery Tender and left in on. So I went to start it up this weekend and sure enough it was dead. Furthermore the fluid level was low in most of the cells. Rather than buy a new battery once again, is there a product that can be added to the cells to bring this one back? I know from past experience just adding distilled water to the dry cells and charging typically does not work. Any suggestions/recommendations will be appreciated.
-
While on a ride Saturday evening, my light started blinking indicating my battery. When I got home, sure enough, several cells in the battery were low. I picked up some distilled water and filed it back up. The point I want to make is the next time you are tinkering with your bike, pull the cover off and look to see how full the battery is. And if is low, make sure you fill it with distilled water. You may have cells that are low and the sensor may not be picking it up because that particular cell is not that low. This will ruin a good battery if left too long low on water. RandyA
