MHB Need help writing a pure math formula

Click For 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 'Claude used to facilitate a cyberattack'

Anthropic announced that an inflection point has been reached where the LLM tools are good enough to help or hinder cybersecurity folks. In the most recent case in September 2025, state hackers used Claude in Agentic mode to break into 30+ high-profile companies, of which 17 or so were actually breached before Anthropic shut it down. They mentioned that Clause hallucinated and told the hackers it was more successful than it was...
View full post »

Similar threads

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