help. needed with comparing 2 cells see message

  • Thread starter Thread starter bobby
  • Start date Start date
B

bobby

i need to compare 2 cells. e.g.
if A1 and A2 are both less then 85 then return 0
if a1 is > or = to 85 and a2 is less then 85 then
calculate (a1-84)
if a2 is > or = to 85 and a1 is less then a5 then
calculate (a2-84)
if a1 and a2 are greater then or equal to 85 then
calculate [(a1-84)+(a2-84)]

is this possible using functions? please help.
 
i need to compare 2 cells. e.g.
if A1 and A2 are both less then 85 then return 0
if a1 is > or = to 85 and a2 is less then 85 then
calculate (a1-84)
if a2 is > or = to 85 and a1 is less then a5 then
calculate (a2-84)
if a1 and a2 are greater then or equal to 85 then
calculate [(a1-84)+(a2-84)]
Click to expand...

=(IF(A1<85,0,A1-84)+IF(A2<85,0,A2-84))
 
Back
Top