Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

embedded if function

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Embedded IF function

Embedded IF function

ResolvedVersion 2013

Embedded IF function

Hi there,

I was wondering if it were possible to embed an IF function and and IF Error function.

My current function is =IFERROR(TODAY()-I6,"NA"), whereby cell I6 is a date and if there is an error (as the cell contains "NA") in I6 the value returned is NA. This currently work fine.

I am wanting to add another layer to this function, whereby if cell F6="N" to return no value (or NA - either option is suitable).

If you would like me to forward the spreadsheet please let me know.

I look forward to hearing from you.

Kind regards,
Siobhan

RE: Embedded IF function

Hi Siobhan

Try using this formula

=IF(F6="N","NA",IFERROR(TODAY()-I6,"NA"))

Similar to what you have with an IF wrapped round!

Doug
Best STL

Excel tip:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.