IF Function not working as I want
 

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?

Try getting rid of the quote marks and the equals in the middle of the formula.

IF Function not working as I want
 

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thank you!!!

Cutting out a process
 

Hi,

Am Mon, 2 Apr 2012 09:37:01 +0000 schrieb FooFighter616:

Continuing on from this however, I now need to cut out a process.
Currently I have this formula "=IF(L181<2400,$M$180*H181/$B$255,0)". The
cell B255 contains the formula
"=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)".

Basically, I want to cut out the cell B255 and have the whole thing in
one formula. Is this possible and how would I do this?

you have to replace $B$255 in the first formula with the formula into
B255:
=IF(L181<2400,$M$180*H181/SUMIF(L$181:L$234,"<2400",$H$181:$H$234),0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2