If formula problem

[Phoenix]

I need the formula to do the following:
if i mark an "x" in E18 if i sell motorbikes today, and the total wil
automatically be C18*D18*E9=total. If i buy motorbikes today i need th
same operation, but the total will be in minus(C18*D18*E10=-total).
need a formula that covers all the "x" (for today and tomorrow), bu
always just one "X" in the same line

I used something like this formula before, with "index" and "match
operations.

Any suggestions guys?


Phoeni

Attachment filename: if formula.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46508

 

[Bob Phillips]

Hi Phoenix,

How about

=C18*D18*(OR(E18="x",F18="x"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Phoenix]

Not quite....cause the "x" refers to the factors over. when we make a
"x" for example in E18, the result will be C18*D18*E9. That is if w
sell. When buying the result will the factor for selling.

Phoeni

 

[Bob Phillips]

That's not what is says on the website.

The thing I don't get is how to know if it is buy or sell, if it is cars or
bikes, what data item says that. The basic formula just needs the factor
adding

=C18*D18*(OR(E18="x",F18="x"))*E9 (or is it E8, F8, F9, E10, F10, E11, F10,
E11, F11, E12 or F12?).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)