Hi All,
I have some data as the following:
<tbody>
</tbody>
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 :
but unfortunately, it ends up in #VALUE ! error .
Any Suggestions ?
Regards,
Mohamed El-Ghareeb
I have some data as the following:
P | R | T | V | X | |
Salary | Rise (1) | Rise (1) Date | Rise (2) | Rise (2) Date | |
90 | 10 | 20 | March 17, 2018 | 30 | March 19, 2018 |
<tbody>
</tbody>
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 :
Code:
=IF(X90>T90,V90,R90),IF(T90>=TODAY(),R90,P90)
but unfortunately, it ends up in #VALUE ! error .
Any Suggestions ?
Regards,
Mohamed El-Ghareeb