Follow this topic

Last answered:

04 Jul 2024

Posted on:

29 Jun 2024

0

data table issue

in Introduction to Excel / Perform Sensitivity Analysis with Excel's Data Tables Functionality

All the results in the table I got is the same result with the same number 1611

1 answers ( 0 marked as helpful)

Instructor

Posted on:

04 Jul 2024

0

Hi,

I believe I've also had this happen when i select the row and column inputs incorrectly. Please try to invert them.

Alternatively, there could be an issue with the formula calculating 1,611 in the table above.

Best,

Ned

Submit an answer

related questions

Mario Contreras

1

12

Why are we using SUMIF to transfer data instead of using VLOOKUP?

0

10

Resolved: Sensitivity Analysis with Data Tables

Yuvraj Shivaji Dhepe

0

10

Resolved: How to solve data entry exercise test ?

1

6

fixing the entire source table

Mohammad Abdullah Ansari

0

6

Resolved: How did you select all the table rows and columns in one click?

0

4

Data Table Row & Column Assigning

0

4

filter shortcut key for opening data of that filter button

0

4

Data Validation