formula returns text

[bruce forster]

I have written a formula directly into a worksheet cell. unfortunately the result is displayed as text and not numberic. can anyone help??

 

[GAIL HORVATH]

format the cell as a number not text

I have written a formula directly into a worksheet cell. unfortunately

the result is displayed as text and not numberic. can anyone help??

 

[Gord Dibben]

Bruce

Either you have View Formulas checked in Tools>Options>View or
the cells are pre-formatted as text.

Hit CRTL + `(above TAB key) to toggle Formula View on/off, if that is the
case.

If text cells, select the cells and Format as General then re-enter by
selecting a cell and hitting F2 then <ENTER>.

For a bunch of formulas a quick way to re-enter them is to select the cells
then Edit>Replace

what: =
with: =

Replace all.

Gord Dibben Excel MVP

 

[CLR]

Be sure the formula has it's leading equal (=) sign, like
=A1+B1..........sometimes when I'm structuring long formulas I'll leave it
off till the end and then forget..........

Vaya con DIos,
Chuck, CABGx3

I have written a formula directly into a worksheet cell. unfortunately

the result is displayed as text and not numberic. can anyone help??

 

[bruce forster]

Tried everyones suggestion and still not working. Again the following formula is directly in an excel worksheet..not VBA. The following formula gives the right result but in text format. I can not format into currency. I have confirmed the cells are formatted correctly. Don't know what is up

=if(IncStmtAssump!B14="Input",IncStmtAssump!C14,"")&if(IncStmtAssump!B14="% of Revenue",Vlookup("Revenue",Sheet1!$A$1:$I$55,8,false)*IncStmtAssump!C14,"")&If(IncStmtAssump!B14="Tax Rate",vlookup("Earnings Before Taxes",Sheet3!$A$1:$J$55,2,false,""

I really need this to work because bosses boss is expecting something Monday

Thanks

 

[Ragdyer]

Maybe you're being misunderstood.

You keep repeating that you're answer is in text.
Do you perhaps mean that you're getting digits, but the *digits* are *text
digits*.

If that be the case, try a double unary after the equal sign, before the IF,
and see if that does return what you expect.
=--IF(IncStmtAssump!B14="Input", ... etc.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Tried everyones suggestion and still not working. Again the following

formula is directly in an excel worksheet..not VBA. The following formula
gives the right result but in text format. I can not format into currency.
I have confirmed the cells are formatted correctly. Don't know what is up.=if(IncStmtAssump!B14="Input",IncStmtAssump!C14,"")&if(IncStmtAssump!B14="%
of
Revenue",Vlookup("Revenue",Sheet1!$A$1:$I$55,8,false)*IncStmtAssump!C14,"")&
If(IncStmtAssump!B14="Tax Rate",vlookup("Earnings Before
Taxes",Sheet3!$A$1:$J$55,2,false,"")

 

[CLR]

Could be maybe your VLOOKUP tables are set up as TEXT FORMAT and they are
bringing it to the cell with your formula...........maybe just change the
tables to numbers format.........

Vaya con DIos,
Chuck, CABGx3

Tried everyones suggestion and still not working. Again the following

formula is directly in an excel worksheet..not VBA. The following formula
gives the right result but in text format. I can not format into currency.
I have confirmed the cells are formatted correctly. Don't know what is up.=if(IncStmtAssump!B14="Input",IncStmtAssump!C14,"")&if(IncStmtAssump!B14="%
of
Revenue",Vlookup("Revenue",Sheet1!$A$1:$I$55,8,false)*IncStmtAssump!C14,"")&
If(IncStmtAssump!B14="Tax Rate",vlookup("Earnings Before
Taxes",Sheet3!$A$1:$J$55,2,false,"")