IF Help

[Mick EXCEL newbie]

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(B28>0.01,1) is what it keeps defaulting to yet what i need is
=IF(B28>0.01,01)

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

Many Thanks

 

[Dave Peterson]

If you want text returned:
=IF(B28>0.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(B28>0.01,01,"not greater than 0.01")

 

[Mick EXCEL newbie]

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]

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(B28>0.01,"01","")
(or whatever you figured out)