| 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? |
| 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 | |||
Threaded Mode
