Sorting

[Jan Kronsell]

I have made a spreasheet for a friend. I G11 I have this fomula:

=IF(I11="paid",B7-E11+F11,B7)

end from G12 to G21 I have

=IF(I12="paid",G11-E12+F12,G11)


Now my friensd tries to sort the range from A11 to L21. based on column G,
but this of coourse messes up the results in columns G, creating #VALUE!.
messages in some cells, and wrong results in other.

Is there anyway to create the formulas, so you can sort the spreadsheet, and
still have the formulas pointing at the right cells?

Jan

 

[Dave Morison]

I have made a spreasheet for a friend. I G11 I have this fomula:

=IF(I11="paid",B7-E11+F11,B7)

end from G12 to G21 I have

=IF(I12="paid",G11-E12+F12,G11)


Now my friensd tries to sort the range from A11 to L21. based on column G,
but this of coourse messes up the results in columns G, creating #VALUE!.
messages in some cells, and wrong results in other.

Is there anyway to create the formulas, so you can sort the spreadsheet, and
still have the formulas pointing at the right cells?

Jan

The content in the cells are sorted not the cells themselves.

 

[Jan Kronsell]

I know that its the content, that is is sorted .-).

But then I change my question:

Is it possible to change my formula:

=IF(I12="paid",G11-E12+F12,G11)

so it stills points to the cells, where the content of present G11, E12 and
F12 "ends up" after a sort?

Jan