showing a cell when it is not blank and ignoring it if it is
Maybe in A3
=IF(A150,A2,0)
Mike
"Neil" wrote:
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
|