Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
General Calculator
Perhaps:
=IF(N8<"",M8/N8,IF(O8<"",M8*O8,IF(P8<"",M8-P8,M8))) -- Gary''s Student - gsnu201001 "MIKEY" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PMT calculator | Excel Discussion (Misc queries) | |||
Format: General - Text - General | Excel Worksheet Functions | |||
uk tax calculator | New Users to Excel | |||
calculator | Excel Discussion (Misc queries) | |||
calculator | Excel Discussion (Misc queries) |