Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What does ! mean in the formula?
What does the ! mean before a cell when transferring the cell contents to a
different page? |
#2
|
|||
|
|||
If it's in a string, it means it's a point of emphasis:
=if(a1=1,"Get too work!","Please, continue to work.") if you see it a reference, it's excel's delimiter to separate the sheetname from the address: =sheet1!a1 or ='this is sheet 1"!a1 The formulas return the value from that sheet in cell A1. Juanita wrote: What does the ! mean before a cell when transferring the cell contents to a different page? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |