If statement; How to do something similar to - if(a1-a2>=5,+5)

  • Thread starter Thread starter Magoo
  • Start date Start date
=IF(A1+B1>=5,.05,0)
or maybe you are looking for something like. You didn't say
=a2+IF(A1+B1>=5,.05,0)
=123+IF(A1+B1>=5,.05,0)

Don Guillett
SalesAid Software
(e-mail address removed)
 
=IF(A1+B1>=5,.05,0)
or maybe you are looking for something like. You didn't say
=a2+IF(A1+B1>=5,.05,0)
=123+IF(A1+B1>=5,.05,0)

Don Guillett
SalesAid Software





- Show quoted text -
Click to expand...

Don, What I would like to do is have the Cell be the Sum of a1-a2 but
with a twist.
If the sum is Less than or equal to 5, I would like to add 0.5 and
have that show up in the cell.
If the sum is Greater than that I just want the normal result.

for instance;
a1=40
a2=35

The difference of these would normally be 5. But I would like the
formula to add an additional 0.5 to that figure making it 5.5.

on the other hand if;
a1=40
a2=32

The difference would be 8. At this point would not need to add the
additional 0.5. So the Cell's Contents would remain 8.

I hope this makes sense...
Thanks for your Help!
 
A1-A2 is a difference, not a sum, which confused us. Also it wasn't clear
what you meant by +5 or +0.5. Try this:

=A1-A2+IF(A1-A2<=5,0.5,0)

- Jon
 
=IF(A1+B1<=5,A1+B1+.05,A1+B1)


Magoo said:
Don, What I would like to do is have the Cell be the Sum of a1-a2 but
with a twist.
If the sum is Less than or equal to 5, I would like to add 0.5 and
have that show up in the cell.
If the sum is Greater than that I just want the normal result.

for instance;
a1=40
a2=35

The difference of these would normally be 5. But I would like the
formula to add an additional 0.5 to that figure making it 5.5.

on the other hand if;
a1=40
a2=32

The difference would be 8. At this point would not need to add the
additional 0.5. So the Cell's Contents would remain 8.

I hope this makes sense...
Thanks for your Help!
Click to expand...
 
Back
Top