Thanks Deborah,
I think i might have not been as clear as needed.
When I put in
If I select "26xAnnual" from the drop down list for D1
and have E1 with the following formula: =IF(Income_ESI!D1 = Extras!C3,Extras!D3,0)
E1 Has a Value of 2.66666667 which is Great and what I want.
However, If I select "12xAnnual" from the drop down list for D1
and have E1 with the following formula: =IF(Income_ESI!D1 = Extras!C3,Extras!D3,0)
E1 Has a Value of 0 which is not the desired outcome
The desired outcome would be 1.0000000000
How can i get both outcomes to be as expected?