Le 4 mai 2021, la plateforme Yahoo Questions/Réponses fermera. Elle est désormais accessible en mode lecture seule. Aucune modification ne sera apportée aux autres sites ou services Yahoo, ni à votre compte Yahoo. Vous trouverez plus d’informations sur l'arrêt de Yahoo Questions/Réponses et sur le téléchargement de vos données sur cette page d'aide.
excel function question (using two sheets)?
=IF(data!a4=0, "", data!A4)
If you're confused by the specific function, it's a serial number somebody inserts into the data sheet. If it's blank, it continues to show a "0" in my second sheet with the function =data!a4
this function works as =if(a4=0, "", a4) in the data sheet, so why doesn't it work on a separate sheet?
also, something weird. I have made columns with a function =(data!b4), dragged down and worked well. When I go to edit the function is just leaves the function in the cell, and not giving the function's value. I've also noticed this sheet (which was copied into this current workbook) doesn't color code the functions as I write them. What I mean by that- is when I list a cell as a value it doesn't turn blue/green as it usually does. Since this sheet is somebody Else's work I was unsure of certain settings that may be present.
Any thoughts?
a little more in depth to what I'm trying to accomplish. I have a workbook with 2 sheets, first sheet contains the data from torques. In the A column I have an max amount of 30 serial numbers. The second sheet is a average printout of different torque values. asically,
I made the function =IF(data!a4=0, "", data!A4) because: he first row in sheet 2 copies what serial numbers are in the data sheet. With the plain =data!a4 function, it gave values of 0 for the cells which did not have a serial number. I didn't want several rows showing a 0 (since we usually only do about 15 of the 30 serials). So if the data sheet cell, a30 for example has no value,it will give sheet to a value of "", which takes away the 0.
2 réponses
- il y a 1 décennieRéponse favorite
any idea of the error you are getting? i always suggest people name their cells to be used across worksheets. on the "data" sheet, click on a4, next to the entry line there is a box that says "A4", click on the "A4", name the cell (e.g. "serial_number") and hit enter. you can also hit ctrl+f3 to get into the name manager and create a new name (make sure it is for the entire workbook, not just a specific sheet).
you can then go to your second sheet and type in the name (e.g. "serial_number") or you can hit f3 and select the name and excel will automatically insert for you.
also, is the serial number entry box equal to 0 or equal to ""? you may want to try....
=if(or(data!a4="",data!a4=0),"",data!a4)
hope that helps.
- il y a 5 ans
You sould use the 'replace' functionality to interchange a million with one 2 with 2 and so on. different than for that there an no applications geared up into excel to do it. nevertheless which you will purely might desire to interchange 10 situations (for digits 0 to 9) and you would be comprehensive., replace is interior the edit menu or hit Ctrl+H
