Formula for value

**tariqnaz2005** · 11-15-2009, 07:23 AM

Hi all,

This is might be a small thing for you but honestly it hanged me up?

Pls look attached sheet and do a favour,

What i need is if column A, B, C is having a value then it should go to Column D.

Thanks

Book2.xls

**martindwilson** · 11-15-2009, 07:27 AM

if it's that simple
=A2&B2&C2
but that would be a text number so try
=--(A2&B2&C2)
or
=(A2&B2&C2)+0
=value(A2&B2&C2)

**tariqnaz2005** · 11-15-2009, 07:37 AM

Thanks..for quick response..its solved..

But is there a IF formula for this matter?

Can you give me that..

**DonkeyOte** · 11-15-2009, 07:59 AM

As outlined you don't need an IF.

If you have more than three cells etc and or multiple values and you want only the last number then use:

=LOOKUP(9.99999999999999E+307,A2:C2)