Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
I am trying to write a code but I can't work out how to do it.
The code is =if(a1=f1,"1",) How do I add =if(a1=f2,"2","") Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
Hi Greg
=IF(A1=F1,1,IF(A1=F2,2,0)) but if you want to further add f3, f4, f5 , ... then =MATCH(A1,F1:F1000,0) may be what you want HTH. Best wishes Harald "Greg" skrev i melding ... I am trying to write a code but I can't work out how to do it. The code is =if(a1=f1,"1",) How do I add =if(a1=f2,"2","") Thanks in advance Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code
Thank you for that
Works great Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
option buttons run Click code when value is changed via VBA code | Excel Programming |