View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lemony_M Lemony_M is offline
external usenet poster
 
Posts: 4
Default Complicated formula

I need to multiply a number by a value in a cell but if the number is greater
than 3 it needs to be muliplied by a value in a different cell if that makes
any sense at all!!
I also need to be able to do the above but with 3 different values (e.g less
than three, 4 to 9 and greater than 10) Please help as I am getting very
annoyed with myself!!