I want to be able to enter "D" and have it equal to 6, and "E" equal to 8.75
in the same cell. For example. I enter "D" and it converts the letter into
6 so it can be multiplied by another cell.
I want to be able to enter "D" and have it equal to 6, and "E" equal to 8.75
in the same cell. For example. I enter "D" and it converts the letter into
6 so it can be multiplied by another cell.
Assuming that you will enter "D" or "E" in Cell A1 and the other cell involved in the multiplication is B1, then you can enter this formula in Cell C1Originally Posted by Amy Maestas
=B1*if(A1="D",6,if(A1="E",8.75,1))
BTW, the last number "1" simply means that if Cell A1 is neither "D" nor "E" then Cell C1 will simply be equal to B1. You can always change this last argument to suit your requirements.
Hope this is the formula that you are looking for.
Last edited by BenjieLop; 02-18-2005 at 02:38 PM.
BenjieLop
Houston, TX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks