IF Help

  • Thread starter Thread starter Mick EXCEL newbie
  • Start date Start date
M

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
 
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")
 
Many thanks had just fathomed it out. There is no need for else within this
function although i am still very new to EXCEL.
 
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)
 
Back
Top