Board index » Excel » Where next, I'm not sure and need help

Where next, I'm not sure and need help

Excel65
Hi All,



cell AN1009 formula



=IF(AO1009>=AM1009,"RETURNS OVERDUE","RETURNS RECIEVED")



I need to expand this where if AO1009 is < AM 1009 "Returns revieved

but late" appears in AN1009.



Anyone help I can't get it to work when I change it.



TVM



Joe


-
 

Re:Where next, I'm not sure and need help

=IF(AO1009>=AM1009,"RETURNS OVERDUE", IF(AO1009<AM1009,"RETURNS

REVIEVED","RETURNS RECIEVED"))



--



Rodrigo Ferreira





"deaconj999" <deaconj999@btinternet.com>escreveu na mensagem

Quote
Hi All,



cell AN1009 formula



=IF(AO1009>=AM1009,"RETURNS OVERDUE","RETURNS RECIEVED")



I need to expand this where if AO1009 is < AM 1009 "Returns revieved

but late" appears in AN1009.



Anyone help I can't get it to work when I change it.



TVM



Joe







-