IF formula

[Lology]

Hi All,

I have some data as the following:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]P[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]V[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]Salary[/TD]
[TD="align: center"]Rise (1)[/TD]
[TD="align: center"]Rise (1) Date[/TD]
[TD="align: center"]Rise (2)[/TD]
[TD="align: center"]Rise (2) Date[/TD]
[/TR]
[TR]
[TD="align: center"]90[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]March 17, 2018[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]March 19, 2018[/TD]
[/TR]
</tbody>[/TABLE]





What I want is when X90 is > T90 then V90 should be the TRUE value and R90 should be the FALSE value, and when T90 is >= Today's date then R90 should be the TRUE value, otherwise all of that the value should be P90 ...

below the best I've got so far :

=IF(X90>T90,V90,R90),IF(T90>=TODAY(),R90,P90)

but unfortunately, it ends up in #VALUE ! error .

Any Suggestions ?

Regards,
Mohamed El-Ghareeb

 

[thisoldman]

What is the correct answer for the example you posted?

 

[Lology]

Idk, am trying to figure it out ...

 

[Joe4]

Idk, am trying to figure it out ...

If you don't know what you want it to return, then how we can program something for you?

Your question seems very confusing, as you show numbers in your example, but mention TRUE and FALSE in your description. So, not quite clear what you are hoping to return.

Also note that formulas can only return values to the cells that the formulas are found in, not to other cells.

The reason why you are getting an error is because the formula you posted has two many arguments. IF only has three arguments:
=IF(condition, what to return if true, what to return if false)
If you "nest" your IF formulas, the second IF must be in either the TRUE or FALSE argument. It cannot be after it (nothing can be).

I think it may be better to approach this differently.
List out the different possibilities, and what should be returned in each cell for each of the possibilities. Then perhaps it will be clearer.

 

[kvsrinivasamurthy]

Try this

=IF(X90>T90,V90,IF(T90>=TODAY(),R90,P90)

 

[Lology]

Try this

=IF(X90>T90,V90,IF(T90>=TODAY(),R90,P90)

It works, thanks alot ...