Third Option For IF

[tslayer]

Need to be able to give a third option of TBD if two values are equal.

My formula so far: =IF(D3>D7,B3,B7)

Works fine except when values in D3 & D7 are equal.
It then returns the value in D7. I need it to be blank or show TBD

Thanks

[TMS]

=IF(D3>D7,B3,IF(D3<D7,B7,”TBD"))


Regards, TMS

[TMS]

Thanks for the rep,


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[tslayer]

If I cut and paste the solution above it gives me an error. I believe it has something to do with the quotations in this part of the equation? The only way I got it to work for now is by adding TBD into another cell in this case H3 and then reference that cell as follows:

= IF(D3>D7,B3,IF(D3<D7,B7,H3))

Appreciate the help!

[TMS]

It's something to do with the characters being picked up when copying from the web page ... not sure why.

Copy and paste the formula as typed above and paste it into the formula bar BUT, before pressing Enter, delete the quotes and retype them.


Regards, TMS

[tslayer]

Perfect! Thanks

[TMS]

You're welcome.