If then else....

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

Guest

Question...
How do I write a formula in cell A1 to make this happen:
If the cell A5 is blank or "0" I need Excel to return the value of cell B7.
Otherwise it should be the value og A5.

I know how to restrict making sure that the cell is never empty - if that
makes it easyere..

Please can anyone help me?

rgs Susanne
 
=IF(OR(a5="",A5=0),B7,A5)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Hide columns based on row values 2
Use Formula from another worksheet 3
Function to Return a Date Value Q 4
Error with sum formula in excel 2007 4
How to Control a formula by a character in adjacent column on same 4
Using multiple IF conditions 3
HELP please... easy function 2

Back
Top