|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 25th, 2010, 08:30 AM
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
March 25th, 2010, 10:14 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
