I am reasonably new to Excel and having a couple of problems.
The first is the following which is probably to do with formatting.
=IF(B280.01,1) is what it keeps defaulting to yet what i need is
=IF(B280.01,01)

I have tried everything i can think of formatting wise, any ideas?

Many Thanks

If you want text returned:
=IF(B280.01,"01")

If you want the value to still be a number (not just digits in a text string),
you'll have to format the cell:

(xl2003 menus)
Format|cells|number tab|custom category
00

I'm kind of surprised you don't have an "else" portion in your formula:

=IF(B280.01,01,"not greater than 0.01")



Mick EXCEL newbie wrote:

I am reasonably new to Excel and having a couple of problems.
The first is the following which is probably to do with formatting.
=IF(B280.01,1) is what it keeps defaulting to yet what i need is
=IF(B280.01,01)

I have tried everything i can think of formatting wise, any ideas?

Many Thanks

--

Dave Peterson

Many thanks had just fathomed it out. There is no need for else within this
function although i am still very new to EXCEL.

"Dave Peterson" wrote:

If you want text returned:
=IF(B280.01,"01")

If you want the value to still be a number (not just digits in a text string),
you'll have to format the cell:

(xl2003 menus)
Format|cells|number tab|custom category
00

I'm kind of surprised you don't have an "else" portion in your formula:

=IF(B280.01,01,"not greater than 0.01")



Mick EXCEL newbie wrote:

I am reasonably new to Excel and having a couple of problems.
The first is the following which is probably to do with formatting.
=IF(B280.01,1) is what it keeps defaulting to yet what i need is
=IF(B280.01,01)

I have tried everything i can think of formatting wise, any ideas?

Many Thanks

--

Dave Peterson

So you want to see FALSE when the value in B28 isn't greater than 0.01?

If you want it to look like the cell is empty:
=IF(B280.01,"01","")
(or whatever you figured out)

Mick EXCEL newbie wrote:

Many thanks had just fathomed it out. There is no need for else within this
function although i am still very new to EXCEL.

"Dave Peterson" wrote:

If you want text returned:
=IF(B280.01,"01")

If you want the value to still be a number (not just digits in a text string),
you'll have to format the cell:

(xl2003 menus)
Format|cells|number tab|custom category
00

I'm kind of surprised you don't have an "else" portion in your formula:

=IF(B280.01,01,"not greater than 0.01")



Mick EXCEL newbie wrote:

I am reasonably new to Excel and having a couple of problems.
The first is the following which is probably to do with formatting.
=IF(B280.01,1) is what it keeps defaulting to yet what i need is
=IF(B280.01,01)

I have tried everything i can think of formatting wise, any ideas?

Many Thanks

--

Dave Peterson


--

Dave Peterson