help. needed with comparing 2 cells see message

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.
 
H

Harlan Grove

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)]

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top