MSExcel:Evaluate Blank Cell

[Ladyluck]

OK, now that I have your attention. I want to use an IF statement to evaluate the content of a cell which may be blank or contain a numeric text string. If the cell is blank B1 should preferably be left blank or alternatively contain a zero, if not the content will be multiplied with one to convert the content ot a numeric value (e.g.):

IF (A1 is Blank; Leave B1 Blank; A1*1)
[/color green]
Thanx a bunch
LL

 

[01Patrik]

In B1:

=if(A1="","",textnum(A1))

or

=if(A1="","",A1*1)

...if you want it your way.


// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.

 

[KenWright]

Just another option, albeit you get a 0 and not a blank

=--A1

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------