slparadise
New Member
- Joined
- Jan 30, 2015
- Messages
- 16
I need help creating an ifs formula that will calculate based on a minimum number. Here is an example:
<tbody>
[TD="colspan: 4"]TABLE 1
[/TD]
</tbody>
<tbody>
[TD="colspan: 2"]TABLE 2
[/TD]
</tbody>
The –Widget Length— in TABLE 1 is tied to the –Widget Length—in Table 2 in the form of a drop-down box. I need the $$$PRICE$$$ in TABLE 1 to calculate based on a 500 SF minimum in the –Widget SF— cell but need the formula to recognize that if the number in the –Widget SF—is greater than 500 to use the larger number.
Example:
<tbody>
</tbody>
Widget | --Widget Length-- | --Widget SF-- | $$$PRICE$$$ |
<tbody>
[TD="colspan: 4"]TABLE 1
[/TD]
</tbody>
--Widget Length-- | --Widget Cost-- |
0-24' | 5 |
25'-28' | 10 |
29'-32' | 15 |
33'-36' | 20 |
<tbody>
[TD="colspan: 2"]TABLE 2
[/TD]
</tbody>
The –Widget Length— in TABLE 1 is tied to the –Widget Length—in Table 2 in the form of a drop-down box. I need the $$$PRICE$$$ in TABLE 1 to calculate based on a 500 SF minimum in the –Widget SF— cell but need the formula to recognize that if the number in the –Widget SF—is greater than 500 to use the larger number.
Example:
--Widget Length-- | --Widget SF-- | Formula (Cost * SF) |
0-24’ | 350 | 5 * 500 |
29’-32’ | 750 | 15 * 750 |
<tbody>
</tbody>