formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a formula if a cell A2 is greater 7.5 i need C3 to have the diffrence.
Example A2=8 C3 would automatically becomes .5 Please HELP
 
jodel,

Could use a little more information here???
You mentioned A2 and you want the result in C3, but you want the difference
from what cell????

Let's assume you have a value in A3

The formula in C3 would be:
=IF(A2>5,A2-A3,A2)

Post back with more detail if you still need help.

John
 
typo.....

=IF(A2>7.5,A2-A3,A2)

John

John Wilson said:
jodel,

Could use a little more information here???
You mentioned A2 and you want the result in C3, but you want the difference
from what cell????

Let's assume you have a value in A3

The formula in C3 would be:
=IF(A2>5,A2-A3,A2)

Post back with more detail if you still need help.

John
Click to expand...
 
Try this in C3:

=(A2>7.5)*(A2-7.5)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need to write a formula if a cell A2 is greater 7.5 i need C3 to have the
diffrence.
Example A2=8 C3 would automatically becomes .5 Please HELP
 
Back
Top