View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikey Mikey is offline
external usenet poster
 
Posts: 38
Default General Calculator

Hi all

I have a SUM result in M8 (this is my sub total)
I have a allocated cell Q8 to receive a final Total.

Cells N8,O8,P8 will be allocated the functions /, x, - (Division,
Multiplication, subtraction)

I would like Q8 to display the result of M8 being either /,x, or -
If neither of the 3 function are activated I would like Q8 to display my Sub
Total M8

Hope this make sense
any help would be appreciated
Regards
Mike