-----Original Message-----
Grrrrrr - would help if I read the damn question properly, but in my defence,
I'm having to make assumptions as you haven't closed off the LOG parenthesis in
the numerator example, so I'm going to assume that the last part of your
numerator is actually the base value of the LOG function (But it is an optional
argument so I could be wrong there)!!!!
=LOG((K18*(G17^3))/K17,G18^3)/LOG(H18*H17)
Just clarify the numerator if I was incorrect in my assumption, or the example
may well give you what you need anyway in the form of the syntax to be able to
fix it.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission
---------------------------------------------------------- ------------------
Try the following:-
=LOG(K18*(G17^3))/(K17*G18*(G17^3))
Don't really need the brackets round the G17^3 bit, but
it helps me to read
the
formula.
The 3 represents your m and can be replaced with a cell reference.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
-------------------------------------------------------- --------------------
It's easier to beg forgiveness than ask permission
-------------------------------------------------------- --------------------
the formula is
the numerator=log[K18 x(G17)m(as a superscript)/K17 (G18)m
(as a superscript)
the denominator is log[ H18 x H17]
How do I enter the formula into excel using the cell
locations? I do not know where the parentheses, etc.
go.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 20/02/2004
.
