Actually, if B3 is only 1 of 3 values, we really only need to test if B3 = "Tidewater" (the one that's different from the other 2)
If it's NOT Tidewater, it therefore must be one of the other 2.
=IF(B3="Tidewater",6%,5.3%)*E37
Actually, if B3 is only 1 of 3 values, we really only need to test if B3 = "Tidewater" (the one that's different from the other 2)
If it's NOT Tidewater, it therefore must be one of the other 2.
=IF(B3="Tidewater",6%,5.3%)*E37
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks