| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"if" question
Well, first thing is you need to check your parentheses.
Looks like it should be: =if(c9=x18,y18*g6,if(c9=x19,y19*g6,if(c9=x20,y2 0*g6,"")) Does that change your outcome? "Liz" wrote: I'm writing a formula and struggling to get past one issue. The formula looks like this: =if(c9=x18,(y18*g6),if(c9=x19,(y19*g6),if(c9=x2 0,(y20*g6) x18=100% y18=$99 x19=125% y19=$124 x20=150% y20=$155 etc. The issue is that even when c9=358% the calculation is basing off of the first formula so it seems to be saying "358% is than 100% so we are going to multiply g6 by $99" when I want it to recognize that 358% is actually greater than 150% and multiply g6 by $155. can someone point out where I'm going wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a "tab name" the "chart title"? (question on this) | Charts and Charting in Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
