Need help with and "IF" statement - ASAP

  • Thread starter Thread starter iasiddiqui
  • Start date Start date
I

iasiddiqui

Hello,

I need to write an IF statement. Basically, I want cell A21 = D4
*-if-* a value is present in it. If D4 is blank, then A21 should = D7.
How would I set this up?
 
iasiddiqui said:
Hello,

I need to write an IF statement. Basically, I want cell A21 = D
*-if-* a value is present in it. If D4 is blank, then A21 should = D7
How would I set this up?
Click to expand...

Hi iasiddiqui,

Try this,

=IF(D4>0,D4,D7)

oldchippy :)

Sorry try this instead

=IF(D4=ISBLANK(D4),D4,D7
 

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

Wildcards in If statements 4
I am stumped. Help with Formula... 5
Getting the excel coordinates with oledb 0
conditionally formatting colour of cells 2
Coding issue with Excel 2003 1
Three condition "if" statements 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Networkdays with cells yet to be entered (creating nested if) 2

Back
Top