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