IF Function not working as I want

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
 
C

Claus Busch

Hello,

Am Fri, 30 Mar 2012 15:40:08 +0000 schrieb FooFighter616:
=IF(L182<2400,"=$M$180*H181/$B$255","0")

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top