Excel 2007 IF formula

December 9, 2011 at 05:01:59
Specs: Windows XP
Hi all,

I have a problem which has been infuriating me for some time...

Basically, I have 3 columns. C contains a value, D contains a tick or nothing and I want column E to return the value from column C if column D contains a tick.

I tried using the following, but it only comes up with =C5...

=IF(ISNUMBER(FIND("ü",D5)),"", "=C5")

Your help would be appreciated!!!

See More: Excel 2007 IF formula

Report •

December 9, 2011 at 08:38:51
When you use quotes around a string in Excel, the string is interpreted as Text.

You used "=C5", so the formula returned the text string =C5. If you had used "Blue" it would have returned Blue.

Notice how the FIND function refers to D5 simply as D5.

Try referring to C5 in the same manner

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 9, 2011 at 09:22:23

Using what you have said, I simply removed the quotations and the = symbol to get

=IF(ISNUMBER(FIND("ü",D4)),"", C4)

and it worked!

Much appreciated!

Report •

Related Solutions

Ask Question