after l did the if function l copied it. When go and paste it shows two options paste formulas or paste value. When l paste values l get only the same value in all the cells but that is not what l want. And if l paste formulas it shows 0 everywhere. I had the same problem with the lookup (see the betta buy) later it was fixed after l posted my question on Apple community . So please fix this one too. Plzz
I don't use the iPad version of Numbers (this is the forum of the Mac version) but I think if you looked at the resulting formula in those cells you would probably figure out why they equal zero. All the cell references should have changed.
If you paste a formula from one cell to another, all the cell references will change to be relative to the new cell. For instance, if cell A1 has the formula = B1 and I copy/paste that formula to cell A2, the formula in A2 will be =B2. This is how copy/paste works in spreadsheets. But there is also a thing called "absolute addressing" that will make a reference not change. If the formula in A1 is = $B$1 and I copy/paste that to A2, the result will be =$B$1. The $ in front of the column letter says to make that column "absolute". The $ in front of the row number says to make that row "absolute". You can use either or both.
In the Mac version if you want to put the exact formula in another cell without it changing any of the cell references, you can select the cell, click to bring up the formula editor, copy the formula as if it was text, select the destination cell, type an = (to bring up the formula editor), then Paste. I do not know how to do the same in the iPad version because I don't use it.
If you are going to be filling a formula down/up/left/right or copy/pasting to other cells, you probably want some cell references to stay the same and others to change. Use absolute addressing for those you want to stay the same.
I don't use the iPad version of Numbers (this is the forum of the Mac version) but I think if you looked at the resulting formula in those cells you would probably figure out why they equal zero. All the cell references should have changed.
If you paste a formula from one cell to another, all the cell references will change to be relative to the new cell. For instance, if cell A1 has the formula = B1 and I copy/paste that formula to cell A2, the formula in A2 will be =B2. This is how copy/paste works in spreadsheets. But there is also a thing called "absolute addressing" that will make a reference not change. If the formula in A1 is = $B$1 and I copy/paste that to A2, the result will be =$B$1. The $ in front of the column letter says to make that column "absolute". The $ in front of the row number says to make that row "absolute". You can use either or both.
In the Mac version if you want to put the exact formula in another cell without it changing any of the cell references, you can select the cell, click to bring up the formula editor, copy the formula as if it was text, select the destination cell, type an = (to bring up the formula editor), then Paste. I do not know how to do the same in the iPad version because I don't use it.
If you are going to be filling a formula down/up/left/right or copy/pasting to other cells, you probably want some cell references to stay the same and others to change. Use absolute addressing for those you want to stay the same.
Hi aaliya
Here's the formula you posted as it appears in cell H7:
When the formula is filled into the other cells in column H, Numbers will automatically increment all of the 'unpreserved' row numbers in the cell references by 1 to keep the reference to the cell in the same position relative to the location of the cell containing that iteration of the formula.
In H8, for example, the formula will be IF(C8="A",E3 x G8,IF(C8="B",E4xG8,IF(C8="C",E5xG8,0)))
You want this incrementing for all the cells showing 8 as the row, but the column E references should still be to rows 2, 3, and 4.
To make that happen, open the formula in H7, Click the small triangle on the E2 lozenge, then choose Preserve Row. Repeat with the references to E3 and E4. These three cell references will now show E$2, E$3 and E$4, and will keep that value as you fill them down the column.
Regards,
Barry
Thanks a lot. 🤗It was very helpful. Everything fell in place after l did that.😄Thanks again😇.
Could you plz tell me that how do we name a cell in numbers the way it is done in excel?
If you have "use header names as labels" turned on in Numbers preferences and the table has both a header column and a header row, cells in the table will be given names based on what is in the header column and header row. There is no method for giving a cell a specific name other than that. I, personally, do not use this feature because it makes formulas a lot longer and harder to read than using regular cell references.
Copy pasting IF function to other cells in NUMBERS
