[FooFighter616]

Hello,

So basically I have a spreadsheet with a lot of information on and I need to use an IF function to get a value for certain cells only. This is what I have got so far.

=IF(L182<2400,"=$M$180*H181/$B$255","0")

So L182 is the key cell. If this cell is between 0 and 2400 then it should be true, if not it should be false)

The true value I want to be this formula "=$M$180*H181/$B$255)"

M180 is just a value (8 in this case)

H181 is another value. I want this to change as I drag it down to 182, 183 etc but it is currently just staying as H181.

B255 is another value that has been generate using a SUMIF function using the same criteria as this IF function.

Any suggestions how I can make this work?