=IF(OR(ISBLANK(A1),ISBLANK(A2)),"",IF(A150,A2,0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Neil" wrote in message
...
Hi

I would like A3 in my spreadsheet to show the value of A2 if the value of
A1
is greater than 50.

So

A1 =67 A2= 340 A3= 340
or

A1=0 A2=340 A3=0

Sometimes A1 and A2 will be blank so i would like A3 to return blank and
not
as False as i get so far on my own efforts!

Many Thanks