Prev: How can I count values in multiple non-consecutive cells?
Next: IF - more than seven arguments
From: MIKEY on 25 Mar 2010 04:30
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
From: Gary''s Student on 25 Mar 2010 06:14
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
 | 
Pages: 1
Prev: How can I count values in multiple non-consecutive cells?
Next: IF - more than seven arguments