Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 sets of =if strings in excel 2007
This question references an earlier thread of mine.
If the value of H2=184,then the first =if statement should be used to display a value in B30. If the value of H2=189, then the second =if statement should be used to display a value in B30. The formula is entered in B30. =IF(B29=22,"-12.2",IF(B29=21,"-11.6",IF(B29=20,"-11.0",IF(B29=19,"-10.5", etc... =IF(B29=22,"-12.5",IF(B29=21,"-11.9",IF(B29=20,"-11.4",IF(B29=19,"-10.8", etc... What could be a quick/easy way to express this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 sets of =if strings in excel 2007
You should create a 3 column table like this:
...........A..........B..........C 1...................184.......189 2.......22......-12.2.....-12.5 3.......21......-11.6.....-11.9 4.......20......-11.0.....-11.4 5.......19......-10.5.....-10.8 Then your formula in B30 is: =VLOOKUP(B29,A1:C5,MATCH(H2,A1:C1,0),0) -- Biff Microsoft Excel MVP "v1rt8" wrote in message ... This question references an earlier thread of mine. If the value of H2=184,then the first =if statement should be used to display a value in B30. If the value of H2=189, then the second =if statement should be used to display a value in B30. The formula is entered in B30. =IF(B29=22,"-12.2",IF(B29=21,"-11.6",IF(B29=20,"-11.0",IF(B29=19,"-10.5", etc... =IF(B29=22,"-12.5",IF(B29=21,"-11.9",IF(B29=20,"-11.4",IF(B29=19,"-10.8", etc... What could be a quick/easy way to express this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Named Sets as a filter | Excel Discussion (Misc queries) | |||
Excel 2007 Issue: Charting numerous strings of data | Charts and Charting in Excel | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions |