formula returns text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a formula directly into a worksheet cell. unfortunately the result is displayed as text and not numberic. can anyone help??
 
format the cell as a number not text
bruce forster said:
I have written a formula directly into a worksheet cell. unfortunately
Click to expand...
the result is displayed as text and not numberic. can anyone help??
 
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
 
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



bruce forster said:
I have written a formula directly into a worksheet cell. unfortunately
Click to expand...
the result is displayed as text and not numberic. can anyone help??
 
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
 
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 !
---------------------------------------------------------------------------

bruce forster said:
Tried everyones suggestion and still not working. Again the following
Click to expand...
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,"")
 
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


bruce forster said:
Tried everyones suggestion and still not working. Again the following
Click to expand...
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,"")
 
Back
Top