IF Formulas with Ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cabybake - 13 Dec 2005 18:56 GMT

Hi!
I'm trying to create an IF formula where the workbook will recognize if
there is data added to a column D range (Sessions) and then apply a
formula to the last cell of column F range (Aimline).

Hence, if Sessions (column D) which now has the numbers 1-27 in it gets
28 entered below, then the cell in the same row but column F will take
the number 28 and apply the formula above it =$F$8+($A$12*D35).

Can anyone help?
cabybake

Reply to this Message

Bob Phillips - 13 Dec 2005 19:10 GMT

=IF(D27="","",$F$8+($A$12*D27)

made an assumption that D35 should relate to D28

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi!
> I'm trying to create an IF formula where the workbook will recognize if
[quoted text clipped - 7 lines]
> Can anyone help?
> cabybake

Reply to this Message

cabybake - 14 Dec 2005 15:58 GMT

It worked! I had to change it slightly, but it worked! I have been
working on this for a year and it finally does everything I want. I
cannot believe it! Thank you!!!!!

Here is the new formula I entered: =IF(D36="","",$F$8+($A$12*D36)) I
then copied and pasted it down and it looks perfect. Thanks again,
cabybake

Reply to this Message

Bob Phillips - 14 Dec 2005 16:16 GMT

Well, that sounds like a result!

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> It worked! I had to change it slightly, but it worked! I have been
> working on this for a year and it finally does everything I want. I
[quoted text clipped - 3 lines]
> then copied and pasted it down and it looks perfect. Thanks again,
> cabybake

Reply to this Message