1000-2500 = 0
1900-2500 = 0
2500-2500 = 0
2501-2500=1
2900-2500=400
Also, can this be done in Excel?
2006-09-25 06:08:05 · 4 answers · asked by Justin 2 in Science & Mathematics ➔ Mathematics
You can use the maximum function.
in Excel, use this formula:
=MAX(2600-2500, 0)
Basically, this returns the greatest of two or more values, separated by commas. The first value in this case is 2600-2500, the second is 0.
2006-09-25 06:10:48 · answer #1 · answered by Chris H 2 · 2⤊ 0⤋
Base 2 (binary) for the first 4
your 5th equation doesn't make sense based on the 4 above it
Binary can be programmed in Excel -- use the MOD function with 2 as the base
2006-09-25 13:53:11 · answer #2 · answered by I ♥ AUG 6 · 0⤊ 0⤋
There are many ways to do it :) Some straightforward:
= MAX(a,b) - b
= a - MIN(a,b)
= IF(a
or not so straightforward:
= (ABS(a - b) + a - b)/2
= (SQRT((a - b)^2) + a - b)/2
2006-09-25 15:11:24 · answer #3 · answered by dutch_prof 4 · 0⤊ 0⤋
"A"-"B"="C"
If A>B then C = A-B, else C = 0.
C1 =IF(A1>B1,A1-B1,0)
2006-09-25 13:12:05 · answer #4 · answered by joechem77 2 · 1⤊ 0⤋