Hi guys!
Could you tell me the proper formatting for multiple conditions:
In cell A1 I want to type in values; I want cell B1 to generate a corresponding figure.
For example:
If A1=0 then I want B1 to show 50; if A1=0.1, I want B1 to show 51.6; if A1=0.2, I want B1 to show 53.2, etc.
Thanks in advance! Sorry about the lack of proper terminology!
Bookmarks