If Function neglecting 0 as a number

managingcrap managingcrap is offline

Junior Member

Posts: 8

If Function neglecting 0 as a number

I have this function:

=IF(B1="","",LOOKUP(COLUMNS($A$1:B1)-COUNTIF($A1:B1,"="),{1,2,3,4},{0.2,0.19,0.18,0.17} ))

I'm wanting to modify it in such a way that when I put 0(zero) on A1, the result on B2 would still be 0.2 instead of .19. For some reason, every time I put 0 on A1, the function is recognizing it as a number.

I attached the excel screen shot.

Thanks.

Attached Images

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
function - find first number in row 0, return cell column number	cate	Excel Programming	3	April 19th 11 09:44 PM
R: function - find first number in row 0, return cell column number	r[_4_]	Excel Programming	0	April 19th 11 09:44 PM
How to add cells yet neglecting alphabet dats	perfection	Excel Discussion (Misc queries)	3	April 11th 08 09:47 PM
return cardinal number from ordinal number function - an example	[email protected]	Excel Programming	2	August 15th 05 07:17 PM
Using the autofill function but increment by certain number in function	rishid	Excel Worksheet Functions	1	July 14th 05 07:40 PM

All times are GMT +1. The time now is 09:32 AM.

Menu

About Us