If function to evaluate another formula

[Peteor]

I have the following in cell M2:

=IF(($J$29-$J$28)<=7,$X$4+$X$2,$X$2)

I would like to create the following which references cell M2:

=IF(M2<>"1610.59","602.8","")

The problem I believe I am having is the 2nd If statement is evaluating a formula, rather than the actual cell value. How do I tell Excel to evaluate the value, rather than the first formula?

 

[JoeMo]

You don't need to tell Excel to use the value, it already does that. When dealing with less than, greater than or equals, Excel expects to compare numbers, whereas you are using strings b/c you have enclosed the comparison value in quote marks. Try:

=IF(M2<>1610.59,602.8,"")

 

[Michael M]

I don't follow your logic.
The 2nd if statement is acting on the RESULT of the formula in M2
Can you post an example of the problem ??

 

[Peteor]

Thank you Joe. I always overcomplicate. Been staring at this 4 hours. I was evaluating numbers as strings, and wondering why it would not work.

 

[JoeMo]

Thank you Joe. I always overcomplicate. Been staring at this 4 hours. I was evaluating numbers as strings, and wondering why it would not work.

You are welcome - thanks for the reply.