Thread
:
help with formula
View Single Post
#
2
Don Guillett
Posts: n/a
Have a look in HELP index for
IF
--
Don Guillett
SalesAid Software
"Scudo" wrote in message
...
In cell I8 I put a 1 or 2
If I put 1 then I want cell M7 tp show £150
If I put 2 then i want cell M7 to show £125 and cell M8 to show £125
As a variation if its easier I would be happy with cell I8
If I put 1 then I want cell M7 tp show £150
If I put 2 then i want cell M8 to show £100, as either way it would show
a
total of £250
thanks
Reply With Quote