|
formulas
Is there anyway to set up one cell for different variables?
|
formulas
yes
-- Gary''s Student - gsnu2007 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
For example, we want a cell to have either the value in B1 or C1 depending
upon A1: =IF(AA1=1,B1,C1) -- Gary''s Student - gsnu200752 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
Could you give me some pointers on how to do this?
"Gary''s Student" wrote: yes -- Gary''s Student - gsnu2007 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
would you mind if I gave you an example?
"Gary''s Student" wrote: For example, we want a cell to have either the value in B1 or C1 depending upon A1: =IF(AA1=1,B1,C1) -- Gary''s Student - gsnu200752 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
No problem. Just tell us what you are trying to accomplish.
-- Gary''s Student - gsnu200752 "happy" wrote: would you mind if I gave you an example? "Gary''s Student" wrote: For example, we want a cell to have either the value in B1 or C1 depending upon A1: =IF(AA1=1,B1,C1) -- Gary''s Student - gsnu200752 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
Ok, thanks I really appreciate it. (these are just example amounts) I need to
be able to type in a procedure code and the correct amount pop up. Is there a way to do that? Procedure Code Amounts PSG 100.00 PSG CPAP 200.00 MSLT 300.00 MWT 400.00 "Gary''s Student" wrote: No problem. Just tell us what you are trying to accomplish. -- Gary''s Student - gsnu200752 "happy" wrote: would you mind if I gave you an example? "Gary''s Student" wrote: For example, we want a cell to have either the value in B1 or C1 depending upon A1: =IF(AA1=1,B1,C1) -- Gary''s Student - gsnu200752 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
How about you give us some examples of what you want to do?
Gord Dibben MS Excel MVP On Wed, 31 Oct 2007 11:18:02 -0700, happy wrote: Could you give me some pointers on how to do this? "Gary''s Student" wrote: yes -- Gary''s Student - gsnu2007 "happy" wrote: Is there anyway to set up one cell for different variables? |
formulas
This is called a table lookup. Let's put the table in H1 thru I5:
Procedure Code Amounts PSG 100 PSG CPAP 200 MSLT 300 MWT 400 The table can be very long. We can put the lookup value in A1: PSG In B1 we enter: =VLOOKUP(A1,H2:I5,2) and it displays: 100 I hope this response keeps you "happy" -- Gary''s Student - gsnu200752 "happy" wrote: Ok, thanks I really appreciate it. (these are just example amounts) I need to be able to type in a procedure code and the correct amount pop up. Is there a way to do that? Procedure Code Amounts PSG 100.00 PSG CPAP 200.00 MSLT 300.00 MWT 400.00 "Gary''s Student" wrote: No problem. Just tell us what you are trying to accomplish. -- Gary''s Student - gsnu200752 "happy" wrote: would you mind if I gave you an example? "Gary''s Student" wrote: For example, we want a cell to have either the value in B1 or C1 depending upon A1: =IF(AA1=1,B1,C1) -- Gary''s Student - gsnu200752 "happy" wrote: Is there anyway to set up one cell for different variables? |
| All times are GMT +1. The time now is 12:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com