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