IF Formulas with Ranges

  • Thread starter Thread starter cabybake
  • Start date Start date
C

cabybake

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
 
=IF(D27="","",$F$8+($A$12*D27)

made an assumption that D35 should relate to D28


--
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
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
 
Well, that sounds like a result!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top