if function that i dont get

[domhastings]

i need some help with a formula that i just cant get.

im making a list of items that includes their price, im then spliting
that price by 3 as 3 people are paying. after each items name is its
price and who has payed. i then have boxes with the total each person
has payed.

so some how i need a formula that will add to the persons total if
their name appears in the payed box.

sorry if i have made this more complicated than its needs to be

so far ive got :

=IF(OR(G11="callery"),B24=B24+D11,IF(OR(G11="dom"),D24=D24+D11,IF(OR(G11="derek"),F24=F24+D11)))

but it doesent work

 

[Bob Phillips]

You can't do it that way. A function can only return a result to the cell it
is in, it can't be used to conditionally set one of three. And, you cannot
add a value to a cell to the value already in there.

Explain in narrative what you are trying to do, with some example data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"domhastings" <[email protected]>
wrote in message
news:[email protected]...