MHB Need help writing a pure math formula

AI Thread Summary
The discussion revolves around creating a mathematical formula for a website plugin that calculates a value based on the area defined by length (A) and width (B). The area (C) is determined by the formula A * B, and then a piecewise function applies different multipliers to C based on its value. The specified ranges for C and their corresponding multipliers are outlined, with the user seeking to convert an Excel formula into a pure mathematical representation. A response indicates that the formula is a piecewise function and suggests that the programming language of the plugin may be relevant for implementation.
mcreech
Messages
1
Reaction score
0
Hello,
I am really struggling to write a math formula that I need for my website plugin.

A=(Length) B=(Width) C=(Square Inch)
A*B=C
0<=C<=16 then C*.84
17<=C<=34 then C*.70
35<=C<=65 then C*.56
66<=C<=99 then C*.42
100<=C<=150 then C*.35
151<=C<=500 then C*.31

I wrote this formula in excel, but I need a pure math formula. Here is the excel formula…G2 represents sq in. =IF(G2<=16,G20.84,IF(G2<=34,G20.7,IF(G2<=65,G20.56,IF(G2<=99,G20.42,IF(G2<=150,G20.35,IF(G2<=200,G20.31))))))Any help would be much appreciated, Thanks!
 
Technology news on Phys.org
mcreech said:
Hello,
I am really struggling to write a math formula that I need for my website plugin.

A=(Length) B=(Width) C=(Square Inch)
A*B=C
0<=C<=16 then C*.84
17<=C<=34 then C*.70
35<=C<=65 then C*.56
66<=C<=99 then C*.42
100<=C<=150 then C*.35
151<=C<=500 then C*.31

I wrote this formula in excel, but I need a pure math formula. Here is the excel formula…G2 represents sq in. =IF(G2<=16,G20.84,IF(G2<=34,G20.7,IF(G2<=65,G20.56,IF(G2<=99,G20.42,IF(G2<=150,G20.35,IF(G2<=200,G20.31))))))Any help would be much appreciated, Thanks!

Hi mcreech! Welcome to MHB! (Smile)

What you have there, is a piece wise function.
Writing it mathematically won't help to get it into a website plugin.
What is the language of your website plugin?
 

Thread 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
View full post »

Thread 'Learning data structures and algorithms in different programming languages'

I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...
View full post »

Similar threads

Fortran Help with Fortran 77 Programming for Two-Dimensional Axisymmetric Flow Study
Replies
6
Views
4K
Minimum # of ops to even out an array by....
Replies
9
Views
2K
Studying Skipping Chapters in Stewart’s Calculus? (Pearson's Edexcel IAL Background)
Replies
2
Views
132
Noob needs help for math/MS Excel formula
Replies
17
Views
6K
Physics hw =p need formula help
Replies
5
Views
7K
How can I avoid large exponents in calculations with small answers?
Replies
5
Views
3K
Comp Sci C++ program-help printing columns and rows
Replies
1
Views
15K

Hot Threads

Recent Insights

Back
Top