if function that i dont get
 

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


--
domhastings
------------------------------------------------------------------------
domhastings's Profile: http://www.excelforum.com/member.php...o&userid=24508
View this thread: http://www.excelforum.com/showthread...hreadid=381023

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"
wrote in message
...

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="de
rek"),F24=F24+D11)))

but it doesent work


--
domhastings
------------------------------------------------------------------------
domhastings's Profile:
http://www.excelforum.com/member.php...o&userid=24508
View this thread: http://www.excelforum.com/showthread...hreadid=381023