A
Andrew Holzman
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.
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.