JanetLight
New Member
- Joined
- May 16, 2016
- Messages
- 1
I am using a spreadsheet with three columns
Col a: today I ate at mcdonalds
col b : 10.52
col c: =IF($D675="drink",$F675-$G675,IF($D675="burger king",$F675-$G675,
IF($D675="kfc",$F675-$G675,IF($D675="mcdonalds",$F675-$G675,
IF($D675="wendys",$F675-$G675,IF($D675="taco bell",$F675-$G675,
IF($D675="arbys",$F675-$G675,IF($D675="cams ham",$F675-$G675,
IF($D675="stewarts",$F675-$G675,
IF($D675="chinese",$F675-$G675,
IF($D675="giovannis",$F675-$G675,
IF($D675="ginos",$F675-$G675,
IF($D675="tudors",$F675-$G675,
IF($D675="olive garden",$F675-$G675,
IF($D675="tim hortons",$F675-$G675,
IF($D675="bob evans",$F675-$G675,
IF($D675="steak escape",$F675-$G675,
IF($D675="subway",$F675-$G675,
IF($D675="seven eleven",$F675-$G675,
IF($D675="sheetz",$F675-$G675,
IF($D675="golden corral",$F675-$G675,
IF($D675="******* barell",$F675-$G675,
IF($D675="sheetz",$F675-$G675,
IF($D675="ruby tuesday",$F675-$G675,
IF($D675="logans",$F675-$G675,
IF($D675="drinks",$F675-$G675,
IF(ISNUMBER(SEARCH("*food*",$D553)),$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
"")))))))))))))))))))))))))))))))))
This works and does the calculation I need. But in some cases the formula is excessively long. SO I was hoping to put the entire list of restaurants in a column, give it a range name, and use the name in my formula but it does not return anything.
Any suggestions?
Thank you all!
Janet
Col a: today I ate at mcdonalds
col b : 10.52
col c: =IF($D675="drink",$F675-$G675,IF($D675="burger king",$F675-$G675,
IF($D675="kfc",$F675-$G675,IF($D675="mcdonalds",$F675-$G675,
IF($D675="wendys",$F675-$G675,IF($D675="taco bell",$F675-$G675,
IF($D675="arbys",$F675-$G675,IF($D675="cams ham",$F675-$G675,
IF($D675="stewarts",$F675-$G675,
IF($D675="chinese",$F675-$G675,
IF($D675="giovannis",$F675-$G675,
IF($D675="ginos",$F675-$G675,
IF($D675="tudors",$F675-$G675,
IF($D675="olive garden",$F675-$G675,
IF($D675="tim hortons",$F675-$G675,
IF($D675="bob evans",$F675-$G675,
IF($D675="steak escape",$F675-$G675,
IF($D675="subway",$F675-$G675,
IF($D675="seven eleven",$F675-$G675,
IF($D675="sheetz",$F675-$G675,
IF($D675="golden corral",$F675-$G675,
IF($D675="******* barell",$F675-$G675,
IF($D675="sheetz",$F675-$G675,
IF($D675="ruby tuesday",$F675-$G675,
IF($D675="logans",$F675-$G675,
IF($D675="drinks",$F675-$G675,
IF(ISNUMBER(SEARCH("*food*",$D553)),$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
IF($D675="xxx",$F675-$G675,
"")))))))))))))))))))))))))))))))))
This works and does the calculation I need. But in some cases the formula is excessively long. SO I was hoping to put the entire list of restaurants in a column, give it a range name, and use the name in my formula but it does not return anything.
Any suggestions?
Thank you all!
Janet