Siobhan has attended:
Excel Intermediate course
Excel Advanced course
Project Management - Framework & Processes course
PowerPoint Intermediate Advanced course
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