Need help to replace formulas to be compatible with old versions of excel up to 2010

[Akbarov]

Hello Dear community,

I am trying to replace formulas on worksheet with formulas which can work on all versions of Excel back to 2010 version.
When I am testing compatibity of excel. It shows issues on following formulas. Can anyone tell me what alternative way is to set this formulas?

=SUM(O15:O21)
=extra1cell (named range)
=H61:O61

 

[Dave Patton]

Your information is not very clear.
Please post an extract of your data as well as expected results.
The forum provides a tool named XL2BB.

 

[Akbarov]

I just made compatible test. As you can see on below link

compabilityforum.png

Shared with Dropbox

www.dropbox.com

It is showing cells which will not be compatible for some versions of Excel. And all that cells has following formulas:
=SUM(O15:O21)
=extra1cell (named range)
=H61:O61

 

[Akbarov]

When I click "Find" it jumps to this formula: =IF($H15<>"",$H15,$I15/12)
Any help please?

 

[Dave Patton]

A picture does not help and you provided no information on what you are trying to do!

Is extra1cell a UDF? User Defined Function
What is the extension on the file?
What macros are included?
=SUM(O15:O21) and =IF($H15<>"",$H15,$I15/12) should not be a problem. Are there any characters other than numbers in these ranges or addresses?

If you do not post an extract of your sheet, expected results, and an explanation of what you trying to do, I cannot help.

 

[Akbarov]

A picture does not help and you provided no information on what you are trying to do!

Is extra1cell a UDF? User Defined Function
What is the extension on the file?
What macros are included?
=SUM(O15:O21) and =IF($H15<>"",$H15,$I15/12) should not be a problem. Are there any characters other than numbers in these ranges or addresses?

If you do not post an extract of your sheet, expected results, and an explanation of what you trying to do, I cannot help.

I am really sorry most of problems was because of formula in conditional formatting not on cells. So, I fixed them. Just 1 question. How can I replace SPILL formula to work on 2010 version:
=H61:O61

 

[Leo Skywalker]

I am really sorry most of problems was because of formula in conditional formatting not on cells. So, I fixed them. Just 1 question. How can I replace SPILL formula to work on 2010 version:
=H61:O61

Just type:
=h61
and copy to the right 8 columns. This won't be an array, though, but independent values.

If you need it to be an array, then you need to select a range of the same size (in this case 1 row by 8 columns) and then type =H61:O61 and press CONTROL+SHIFT+ENTER.

 

[Akbarov]

Yes, already did that. I hope there wont be any difference between making it independent or array.