Formula return False

[chris007]

Hello,
Could I have some assitanc please. I have written this formula to return values under certain conditions, however if 0 apears in cell CK3 the word False apears in cell CN3 where I have the formula. How can i stop the False from appearing? if CK has a value other than "0" the correct information is displayed in cell CN3

Formula as I have it at present

=IF(CK3="",0,IF(CK3>=300,'Look Up Table'!$M$10,IF(CK3>=90,'Look Up Table'!$M$11,IF(CK3>=30,'Look Up Table'!$M$12,IF(CK3>=11,'Look Up Table'!$M$13,IF(CK3>=0.03,'Look Up Table'!$M$14))))))

Thanks you

 

[markmzz]

Maybe this (in blue):

=IF(CK3="",0,IF(CK3>=300,'Look Up Table'!$M$10,IF(CK3>=90,'Look Up Table'!$M$11,IF(CK3>=30,'Look Up Table'!$M$12,IF(CK3>=11,'Look Up Table'!$M$13,IF(CK3>=0.03,'Look Up Table'!$M$14,0))))))

Markmzz

 

[Cristy]

at the last if you don't hahe the "value if false" argument and 0 is from this category

 

[chris007]

Guys Thanks,
the placement of the "0" certainly gets rid of teh False, however now it shows 0.00, even with the cell formated to txt it shows 0.

sorry to be a pain how can i get the cell to be blank if cell CK3 shows 0

Thanks

 

[scottylad2]

Try
=IF(CK3="",0,IF(CK3>=300,'Look Up Table'!$M$10,IF(CK3>=90,'Look Up Table'!$M$11,IF(CK3>=30,'Look Up Table'!$M$12,IF(CK3>=11,'Look Up Table'!$M$13,IF(CK3>=0.03,'Look Up Table'!$M$14,,""))))))

 

[chris007]

Guys,
Thank you for your help the ,"" did the trick i don't know why I did not do this, sorry for the hasle and appreciate your assistance

Regards
Chris007