F
FooFighter616
Hello,
So basically I have a spreadsheet with a lot of information on and
need to use an IF function to get a value for certain cells only. Thi
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 i
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 functio
using the same criteria as this IF function.
Any suggestions how I can make this work
So basically I have a spreadsheet with a lot of information on and
need to use an IF function to get a value for certain cells only. Thi
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 i
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 functio
using the same criteria as this IF function.
Any suggestions how I can make this work