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

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top