I need some formula help. I have the following spreadsheet created:

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 50 50 50
100
Programming $1500

Here's what I need:
Programming....If the Enrollment is greater than 0, plug in $1500 (but only
on the Spring column) Now, if the enrollment on Summer is greater than 0,
but the $1,500 has already been filled in on Spring, this must be 0.
Basically, there is a one-time fee of $1500 that will go in when the
enrollment is greater than 0 if no other prior semester has the $1500 on it.

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 0 0 225
225
Programming $1500

In the above instance, the $1500 must show up in Fall '07 b/c the enrollment
doesn't start until then and there is no sum of $1500 in Spring or Summer '07
either.

I have tried if(and) statements and If(or)'s but can't get them to work
right. Keep in mind that the figures in Enrollment can be 0's or greater
than 0's.

Thank you!!!!!

This assumes Spring '07 is in B1 and Programming is in A3:
=IF(OFFSET(A2,0,1)=0,"",1500)

This formula is entered in B3, then fill to the right

Dave
--
Brevity is the soul of wit.


"Pcakes" wrote:

I need some formula help. I have the following spreadsheet created:

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 50 50 50
100
Programming $1500

Here's what I need:
Programming....If the Enrollment is greater than 0, plug in $1500 (but only
on the Spring column) Now, if the enrollment on Summer is greater than 0,
but the $1,500 has already been filled in on Spring, this must be 0.
Basically, there is a one-time fee of $1500 that will go in when the
enrollment is greater than 0 if no other prior semester has the $1500 on it.

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 0 0 225
225
Programming $1500

In the above instance, the $1500 must show up in Fall '07 b/c the enrollment
doesn't start until then and there is no sum of $1500 in Spring or Summer '07
either.

I have tried if(and) statements and If(or)'s but can't get them to work
right. Keep in mind that the figures in Enrollment can be 0's or greater
than 0's.

Thank you!!!!!

This doesn't seem to be working in cells past B3.

(A1) (BLANK) (B1) Spring '07 (C1)Summer '07 (D1)Fall '07
(A2) $1,500.00 (B2) 100 (C2) 100 (D2) 150
(A3) Programming (B3) 1500 (C3) 1500 (D3) 1500

The formula in B3 is: =IF(OFFSET(A2,0,1)=0,"",1500)
and then I copied it forward to C3 and D3, however, the 1500 still appears
in those columns too. Maybe I wasn't too clear in my original email. This
is a one time fee that should only post once the enrollment is greater than
0.

Sorry, it's not really clear what you're looking for. This is what I
understand:

If the enrollment = 225, then the programming row for that period shoul be
1500. Else the programming row for that period should be 0. Is that correct?
--
Brevity is the soul of wit.


"Pcakes" wrote:

This doesn't seem to be working in cells past B3.

(A1) (BLANK) (B1) Spring '07 (C1)Summer '07 (D1)Fall '07
(A2) $1,500.00 (B2) 100 (C2) 100 (D2) 150
(A3) Programming (B3) 1500 (C3) 1500 (D3) 1500

The formula in B3 is: =IF(OFFSET(A2,0,1)=0,"",1500)
and then I copied it forward to C3 and D3, however, the 1500 still appears
in those columns too. Maybe I wasn't too clear in my original email. This
is a one time fee that should only post once the enrollment is greater than
0.

It works if I put 0 in B2, but then the 1500 is still in D3. I need it to
remove the 1500 on any other column if it is filled in on Column A - B. Does
this make sense?

Thank you for your prompt response and I'll keep playing with it. I must
have misinterpreted something. Any other thoughts????? Did I not enter the
formula in the right cell or input it correctly?
"Dave F" wrote:

This assumes Spring '07 is in B1 and Programming is in A3:
=IF(OFFSET(A2,0,1)=0,"",1500)

This formula is entered in B3, then fill to the right

Dave
--
Brevity is the soul of wit.


"Pcakes" wrote:

I need some formula help. I have the following spreadsheet created:

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 50 50 50
100
Programming $1500

Here's what I need:
Programming....If the Enrollment is greater than 0, plug in $1500 (but only
on the Spring column) Now, if the enrollment on Summer is greater than 0,
but the $1,500 has already been filled in on Spring, this must be 0.
Basically, there is a one-time fee of $1500 that will go in when the
enrollment is greater than 0 if no other prior semester has the $1500 on it.

Spring '07 Summer' 07 Fall '07 Spring
'08
Enrollment 0 0 225
225
Programming $1500

In the above instance, the $1500 must show up in Fall '07 b/c the enrollment
doesn't start until then and there is no sum of $1500 in Spring or Summer '07
either.

I have tried if(and) statements and If(or)'s but can't get them to work
right. Keep in mind that the figures in Enrollment can be 0's or greater
than 0's.

Thank you!!!!!