Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
I have 2 formulas; one works and the other doesn't. The second one displays
as text and not a formula. Can someone tell me what to look for? Formula 1 : =Sheet1!B2&", "&Sheet1!C2 : it shows the persons last name, first name Formula 2: =Sheet1!D2 : it shows =Sheet1!D2 (it should be a number 80101) There are 4 formulas on this row which look at the same row of the worksheet. Two of these formulas work and the other to do not; they just display the formula. Thanks, El Bee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula snafu | Excel Discussion (Misc queries) | |||
Toolbars macro buttons snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) |