Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |