showing a cell when it is not blank and ignoring it if it is

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=IF(OR(ISBLANK(A1),ISBLANK(A2)),"",IF(A1>50,A2,0))

--
---
HTH

Bob

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