| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then Logic
I want to do the following but have been have trouble.
IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Logic
In G3 enter:
=3*A13 -- Gary''s Student - gsnu200859 "RPB" wrote: I want to do the following but have been have trouble. IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Logic
Hi,
Try this in g1 =CHOOSE(A13,3,6,9) Mike "RPB" wrote: I want to do the following but have been have trouble. IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Logic
Using IF() formula in G1
=IF(A13=1,3,IF(A13=2,6,IF(A13=3,9,""))) Alternative solutions =A13*3 OR =CHOOSE(A13,3,6,9) If this post helps click Yes --------------- Jacob Skaria "RPB" wrote: I want to do the following but have been have trouble. IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Logic
Thank you all. Most helpful.
"Jacob Skaria" wrote: Using IF() formula in G1 =IF(A13=1,3,IF(A13=2,6,IF(A13=3,9,""))) Alternative solutions =A13*3 OR =CHOOSE(A13,3,6,9) If this post helps click Yes --------------- Jacob Skaria "RPB" wrote: I want to do the following but have been have trouble. IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then Logic
Another option might be:
=IF(OR(A13={1,2,3}),A13*3,"") = = = HTH RPB wrote: I want to do the following but have been have trouble. IF A13=1, then G1=3, IF A13=2, then G1=6 and IF A13=3, then G1=9 Can anyone help???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOGIC | Excel Discussion (Misc queries) | |||
| I Then logic help | Excel Worksheet Functions | |||
| Logic please | Excel Discussion (Misc queries) | |||
| If Then logic not enough | Excel Discussion (Misc queries) | |||
| IRR Logic | Excel Worksheet Functions | |||
Linear Mode
