Formula
Hi,
I assume you want in C1 the difference between B1 and A1
=if((B1-A1)175,175,(B1-A1))
if this helps please click yes thanks
"HeatherV" wrote:
HELP Please! What I'm trying to do is in the one cell a simple sum to work
out the difference between two other cells then (in same cell) I want it to
decide that if the figure returned is greater than £175 I want it to show
£175 but if it is less than £175 I want it to show the actual figure.
Is this possible???
|