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 'Is this public key encryption?'

Thread 'Is this public key encryption?'

I've tried to intuit public key encryption but never quite managed. But this seems to wrap it up in a bow. This seems to be a very elegant way of transmitting a message publicly that only the sender and receiver can decipher. Is this how PKE works? No, it cant be. In the above case, the requester knows the target's "secret" key - because they have his ID, and therefore knows his birthdate.
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
202
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