Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have "IF" formula...
=IF(C67=G69;M4;0) c69 - number. m4 result if c67=g69 0 if not. When I'm copying that formula (dragging with mouse.. autopaste) I'm getting autochanging in formula =IF(C68=G70;M5;0) ,, =IF(C69=G71;M6;0) a problem is I dont wanna that G69 will change, so it will be in all others functions. How can I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Problem.Please advise. | Excel Discussion (Misc queries) | |||
Data sorting, please can anyone advise on the best function to use? | Excel Discussion (Misc queries) | |||
Newbie: worksheet function advise (huge please) | Excel Worksheet Functions | |||
pls advise | Excel Worksheet Functions | |||
VBA Advise | Excel Programming |