IF functions

[Guest]

I am inputting and IF function formula and am wondering why I am getting and
False in my cell. here is the formula I am using
IF(F4-D4*38.46,0=20%*(F4-D4*38.46)=0)

F4 is 1749.56
D4 is 6

 

[Guest]

You have the function mixed up. I am not sure what you are trying to do with
to "=" in the function. F4-D4*38.46 is almost alway not equal to 1 therefore
your function will almost always be false, and since you don't have anything
in the elseif slot of the if function it will almost always output FALSE.

Here is an example of an IF function:
A1:1
B1:5
C1:=IF(A1=B1,"Equal","Not Equal")

C1 outputs "Equal" if A1 is Equal to B1, otherwise it outputs "Not Equal"

 

[Jay]

I am inputting and IF function formula and am wondering why I am

getting and False in my cell. here is the formula I am using
IF(F4-D4*38.46,0=20%*(F4-D4*38.46)=0)

F4 is 1749.56
D4 is 6

Looks to me like there's a typo in the IF statement. IF has three arguments
separated by commas.

To see how Excel is interpreting the statement, select the cell containing
it and click on the command button that looks like it has "fx" in it.
You'll see a popup box with three fields:
1. Logical test F4-D4*38.46
2. Value if true 0=20%*(F4-D4*38.46)=0
3. Value if false <empty>
With that as a starting point, change the three fields to match your
intentions and click OK.

 

[Trevor Shuttleworth]

Looks as though you're not using the function properly ... and I'm not sure
what you are trying to achieve.

The format is:

=IF(condition, value if condition is true, value if condition is false)

In this case, Excel is evaluating "F4-D4*38.46" and reading this as TRUE and
returning the value of "0=20%*(F4-D4*38.46)=0" which is evaluated as FALSE

Regards

Trevor