Thanks, John Machin for reply. What I am trying to do is: Column C and D are dates. Column D and F are dollar numbers. Column G is less than one year - 365 days. Column H is greater than one year - 365 days. The operation I want to perform is:
IF datedif is less than 365 G =sum(Dn - Fn) else H=sum(Dn - Fn) Can this be done? Will it require a formula or an executable script(which I do not yet know how to write)? Any and all suggestions will be greatly appreciated. I will learn! Fred _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
