Thread: IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nic Nic is offline
external usenet poster
 
Posts: 25
Default IF

I have three columns

F is dates
G is dates
H is where the formula is

I would like the formula to show if the date in G is greater than the date
in F show Overdue, else if G is less than F show Complete, else if the date
in G changes from what it currently shows then show Forecast Change.

Any help with this would be greatly appreciated. I realise I may have to
customise this for each row to show the different dates currently displayed
in column G.

Cheers
Nic