appending and IF statement to an existing IF statement

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

Guest

I have a formula that asks if cell B12 is blank, leave the cell in question
blank, but if there is a value in B12, fill the cell in question with the
value of cell B13:

=IF(isblank(B12),"",B13)

I would like to add an additional condition, which is that if the value of
B13 is less than the value of A1, a text error (such as "out of range") is
returned. All cells in question are formatted as dates.

I've tried a few ways of appending a second IF statement to me existing
forumla but am doing something incorrected. Any help is appreciated.

Thanks,
spence
 

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

IF THEN Statement 1
IF Formula Porblems 1
Need help with formula!!!! 2
=AND($B$12<>"",$B$12<TODAY()+60) What does the <> mean in this? 3
How can I lookup when match has more than one value? 2
Fill Series only changing one input 2
If cell value is between XX and XL, display B 4
Worksheet Formula Returning Sum of a Series 16

Back
Top