One nested IF function cell shows incorrect value based on another nested IF function

Dear readers,

Thank you for reading this,

I have cell E91 with a nested IF Function looking like this:

=IF(Hits...Numbers!T11="Ground Armor L1", "1", IF(Hits...Numbers!T11="Ground Armor L2", "2", IF(Hits...Numbers!T11="Ground Armor L3", "3", "0")))

And another cell G104 with a nested IF Function looking like this:

=IF(E91="0","0", IF(E91="1", "1", IF(E91="2", "2", IF(E91="3", "3"))))

While the first cell mentioned E91 shows correctly the value depending on the T11 cell of the sheet 'Hits...Numbers', the second cell G104, which is showing various values depending on E91 (first cell), to my surprise it shows always "3".

It does not matter if cell E91 shows 0, 1, 2 or 3, the cell G104 (the second one with nested IF function) always shows "3".

Could you be so kind to direct me to what the problem might be?

Cheers

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"