IF Formula gives the wrong result

Dear all,

I have a problem with a formula in a few cells with the following formula in the cell h60 on the sheet: Income Statement =IF(($H$3<=$F$52);($G$60-(G60/$F$48));0) but isn't working. Any help solving this pls??

Kind Regards
Fausto

There are extra brackets but it is not disturb your formula
it has to be work
can you attach sample file with expected result

change this … =IF(($H$3<=$F$52);($G$60-(G60/$F$48));0) to this… =IF($H$3<=$F$52;$G$60-(G60/$F$48);0) should work for you.

Originally Posted by Sambo kid

change this … =IF(($H$3<=$F$52);($G$60-(G60/$F$48));0) to this… =IF($H$3<=$F$52;$G$60-(G60/$F$48);0) should work for you.

@ Sambo Kid booth the formulas are giving same result
i didn't find any difference in the results

@ Sambo Kid booth the formulas are giving same result
i didn't find any difference in the results

That's what I get for not testing it, just looking at it.

Ok, now that I read the formula and what it is supposed to do, I don't see what is "not working"? This time I tested mine and yours. So I reread nflsales comment again and He also says it should work.

Multiplication shouldn't need brackets

This should simply be

=IF($H$3<=$F$52;$G$60-G60/$F$48;0)

though this will produce the same answer.
How is it "not working"?

H3 = F52 (Year 1) so the result will be

900,000 - 900,000 / 25 = 900,000 - 36,000 = 864,000
which is what the spreadsheet says

Dear All,

I thank you for your support but the formulas didn't worked.

Can we something else?/

Kind Regards

Fausto

Where it is not working

Can you describe "didn't worked" ?
In what way is it not working for you?
Are you getting the wrong result? What result DO you get, what result did you expect, and why?

It certainly is working for me..it returns 864000

=IF($H$3<=$F$52;$G$60-G60/$F$48;0)

H3 = 1
F52 = 1
So $H$3<=$F$52 is in fact TRUE.

So the formula calculates
$G$60-G60/$F$48

G60 = 900000
F48 = 25
900000-900000/25

900000/25 = 36000

900000-36000 = 864000

What I'm trying to do is: if the cell X is < or = to the cell z, something has to happen but the result it comes always wrong???

Rgs

The point is, the formula is not working as I want to say that if the year 1 at H3 is equal to 1 at F52 than he has to perform the formula and the same to the other cells...

What actual number should the formula return and please explain exactly how you calculate that?

yes but if I insert the number 2 on F52 comparing with H3, the result must be 0

The test in the IF is
$H$3<=$F$52

If H3 is 1, and you put a 2 in F52, then it becomes
1<=2 = TRUE, so it still does the calculation.

Why would it return 0 ?


< means LESS THAN

So $H$3<=$F$52 is saying Is H3 LESS than or Equal to F52


Perhaps the formula should be
=IF(($H$3>=$F$52),($G$60-(G60/$F$49)),0)

will try...