I want to get tax value in one cell by typing another cell 'F' or 'M' is this possible in excel 2007
by 
bishunke
ANSWERS: 2
-
What do you mean "tax value"? Are you trying to make the cell show use a different formula depending on if you put 'M' or 'F' in the other cell?
-
This formula assumes that F or M will be in cell D12: =IF(D12="M","First Value",IF(D12="F","Second Value","")) Replace "First Value" and "Second Value" with the appropriate tax rates and don't use inverted commas - they are only needed for text.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC