View Single Post
  #1   Report Post  
Scudo
 
Posts: n/a
Default help with formula

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