| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Attempting to Copy a IF Function
I need to know how to cascade a IF formula down that will only change the
first value of the Logical Test and will leave the true and false statements unchanged. Example in the formula =IF(B2 = "080012",H2, H3) I need B2 to update as I cascade (copy) down the spreadsheet but I need H2, H3 to remain unchanged. I am not able to find anything on the website to handle this. Even when I copy and paste it updates all three values and not just the one. Can anyone please help me update the function so that only the Logical Test value changes. -- Andrew Holzman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attempting to weight | Excel Discussion (Misc queries) | |||
| I am attempting to create a summary sheet | Excel Discussion (Misc queries) | |||
| Password prompt while attempting to save from website | Excel Discussion (Misc queries) | |||
| ATTEMPTING TO CHANGE MY WATERMARK, BUT SOFTWARE WON'T LET ME | Excel Discussion (Misc queries) | |||
| Attempting Excel Template | New Users to Excel | |||
Threaded Mode
