Skip to main content
Web Applications

Return to Question

Minor improvements
Source Link
marikamitsos
marikamitsos
  • 13.2k
  • 4
  • 35
  • 60

I have the following formula in a Google Spreadsheet:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30Totais!C30 change to Totais!C31Totais!C31, Totais!C32Totais!C32, C33...

I have the following formula in a Google Spreadsheet:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

I have the following formula in a Google Spreadsheet:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32,...

Question Protected by CommunityBot
Tweeted twitter.com/#!/StackWebApps/status/633352686834982912
body text, re-tagging
Source Link
Jacob Jan
Jacob Jan
  • 23.4k
  • 16
  • 107
  • 197

I have the following formula bellow onin a Google Spreadsheet file:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

Is there a way to do it?

Thank you.

I have the formula bellow on a Google Spreadsheet file:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

Is there a way to do it?

Thank you.

I have the following formula in a Google Spreadsheet:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

Source Link
Victor Santos
Victor Santos
  • 563
  • 2
  • 5
  • 6

'Lock' part of formula when copying from one cell to another

I have the formula bellow on a Google Spreadsheet file:

=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))

I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.

Currently when I do this, Totais!C30 change to Totais!C31, Totais!C32, C33...

Is there a way to do it?

Thank you.