Skip to main content
fixed 1 typo
Source Link

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is? IF this is not the appropriate sidesite to have the thought process of a spreadsheet reviewed, where is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is? IF this is not the appropriate side to have the thought process of a spreadsheet reviewed, where is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is? IF this is not the appropriate site to have the thought process of a spreadsheet reviewed, where is?

Added a segment on where to go if this is not the right place
Source Link

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is? IF this is not the appropriate side to have the thought process of a spreadsheet reviewed, where is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is? IF this is not the appropriate side to have the thought process of a spreadsheet reviewed, where is?

tweaked some formatting
Source Link

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False)=IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1=$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has (A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is?

From what I can tell this site is mainly (not sure about solely) for the use of reviewing CODE. I am wondering if it will also review code-free spreadsheets for potentially better formulas, or layout of information, or process?

For example could I post a working spreadsheet that looked something like this:

    (A)    (B)    (C)    (D)
(1)  2      4      8    False
(2)  3      1      3    True

Where C has =(A1*B1) and D has =IF(C1<=5,True,False) and I place some conditional formatting that based on formula =$D1 will colour the row.

and have some one review it and say eliminate column D and set your conditional formatting formula to the same formula you were using in D. Have you considers negative values? Do you really want -8 to be true as well?

OR did I miss the purpose of what Code Review is?

edited tags
Link
Mathieu Guindon Mod
  • 75.6k
  • 4
  • 99
  • 243
Loading
Source Link
Loading