# Re: Complex Calculations

• From: Norman Frederick <normfred charter net>
• To: Ralph Shumaker <rafazap cwnet com>
• Cc: gnumeric-list gnome org
• Subject: Re: Complex Calculations
• Date: Sat, 23 Feb 2008 15:57:25 -0600

```Ralph Shumaker wrote:
```
```Norman Frederick wrote:
```
```

```
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
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

```
First of all, you have column D being both a date and a dollar amount. So let's assume that you meant that column E is the dollar amount.
```You are correct. I goofed. C& E are dates, D & f are numbers.
```
If C and D are both in date format then you should be able to do it like this:
```In cell Gn:
=if(Dn-Cn<365,sum(En-Fn),)
In cell Hn:
=if(Dn-Cn<365,,sum(En-Fn))

There may be a better way.  But I think that this will do what you want.
```
I cannot make this way work. I have tried using datedif to get the number of days but I do not get what I need (nor anything else). Is < a valid less than symbol? I have tried both < and -lt and a window pops up with both saying everything must be valid references. I need to go back to school and refresh my math and programming, but sweetthing says I am to old. Eighty-one ian't old!
```Thanks for the help,
Norman Frederick

```