IF Function returning FALSE

[markb1009]

Have the following formula returning FALSE,

=IF(D11=225,F11=100,"")

Not sure what I am missing again.

Thanks Everyone

 

[Joe4]

I assume that you want the value to return in cell F11.
Then you put this formula in F11:

[COLOR=#333333]=IF(D11=225,100,"")[/COLOR]

(formulas can only return values to the cells they reside in, they cannot return a value to a different cell)

 

[azumi]

Are you need formula return false if not meed the criteria? Just remove the last part

=IF(D11=225,F11=100)

 

[RBone90]

Where you have F11=100 is where your issue lies. I am assuming you are trying to have it say 100 in cell F11. In that case, just put 100. As long as the formula is entered in F11 then 100 will populate if it is true.

 

[markb1009]

Thank you once again, learning slowly but surely.

Have a great day.

 

[markb1009]

Thank you that did it.

 

[markb1009]

Thank you, try to over complicate at times, appreciate the help.