Simplify the formula

Hello all

I am new today to the forum and would like to say hello to all and thanks in advance for the help, assistance and advice to come.

I have written the simple formula below using the 'IF' statment. The formula basically returns a value once a condition is met. My question is that whilst I am proud that I managed to write it without using any assistance, can the formual be simplified? (i.e. shortened to give the same results)?

=IF(G2=G6-3,"Time to update or request details",IF(G2=G6-2,"Time to update or request details",IF(G2=G6-1,"Time to update or request details",IF(G2=G6,"Time to update or request details",IF(G2=G6+1,"ATTENTION!! Details overdue",IF(G2=G6+2,"ATTENTION!! Details overdue","ok"))))))

Many thanks
Ivor

You could use LOOKUP, perhaps

=LOOKUP(G2-G6,{-100000,-3,1,3;"ok","Time to update or request details","ATTENTION!! Details overdue","ok"})

Originally Posted by 6StringJazzer

This reduces the IF nesting...

=IF(OR(G2=G6-3,G2=G6-2,G2=G6-1,G2=G6),"Time to update or request details",IF(OR(G2=G6+1,G2=G6+2),"ATTENTION!! Details overdue","ok"))

Thank you very much 6Sring Jazzer. That is something that will definitely be useful to me, as my new role here requires a lot of excel formula creation/manipulation.

Cheers sir

Hello Daddy Longlegs

Thanks for your reply...WOW as you can tell by my question, my excel skills fall far short of those required to come up with your level of formula......please don't tell me you came up with that off of your head ha haha.

That's great though sir, thanks a lot

Cheers
^_^