Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

**giallofever** · 03-24-2009, 02:05 PM

I have 4 cols, x rows.
I need Column C to check Column B for a numerical value, and if true, return the value in B, and if not true, then return value from A.

Column B are functions formatted as general. The reference made by Sheet2!B is numbers formatted as text as to retain leading zeros.

Here is what I have so far

=IF(ISBLANK($B10),$A10,$B10)

Please Login or Register  to view this content.

Thanks in advance guys.

**Mikeopolo** · 03-24-2009, 02:10 PM

How about =IF(ISERROR(VALUE(B1)),A1,VALUE(B1)) ?

**giallofever** · 03-24-2009, 02:16 PM

Works perfectly, thank you. One problem though. the result does not retain the leading "0"s from the adjacent cell.

Example (B = 0011644399023 while the new value in C is 11644399023.)

I want it to be exactly the same with out having to add something like &"00"&

When I try to format it as text, it shows the functions rather than result.

**Mikeopolo** · 03-24-2009, 02:18 PM

I see...so:
=IF(ISERROR(VALUE(B1)),A1,B1)
should keep whatever is in B1 intact

**giallofever** · 03-24-2009, 02:20 PM

Correct. The numbers are SKUs for products.

Thanks.

**giallofever** · 03-24-2009, 02:22 PM

Thanks Mikeopolo

Problem SOLVED

=IF(ISERROR(VALUE($B10)),$A10,$B10)

Thanks.

Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

LinkBack

Thread Tools

Rate This Thread

Display

Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Re: Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Re: Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Re: Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Re: Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Re: Check cell for data. Tried ISREF, ISBLANK, ISNUMBER, ISTEXT.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions