R
R
Rinat Haisman2020-03-16 12:42:29
Mathematics
Rinat Haisman, 2020-03-16 12:42:29

How to display a formula for calculating data from a table?

There is a table with data:
a2XlLXxtDpwxn2.jpg
There are 5 variables in this table:
1 working day
3 working days
1 sided
2 sided
Number of pieces with a step of 100

The results of calculations in the table are. What formula to choose so that data from it can be easily obtained using 3 variables (I am working on an online calculator)? You can use the following arithmetic operations in a formula:

  • multiplication *
  • division /
  • addition +
  • subtraction -
  • exponentiation (^)


Each variable in the table (with the exception of quantity) can be set to any value.
But only 3 variables can be used in the formula:
  • work days
  • sides of the print
  • number of pieces in increments of 100 (constant)


This is what the calculator looks like:
spoiler
https://cat-print.ru/calc-vizitki/

Loops like if / if else and any others cannot be used.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2020-03-16
@Survtur

Plot charts in EXCEL and try different trend lines. You can also display the trend line formula there.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question