| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I get excel search through a range of numbers e.g. 1.99 - .
How do I get excel to search through a range of numbers for example the
equation that I would like to complete is IF(B5=1.99 - 1.5,10) but excell thinks that 1.99 - 1.5 is 1.99 minus 1.5. Please help. Matthew |
|
#2
|
|||
|
|||
|
Hi
=IF(AND(B5=1.5,B5<=1.99),10,"not defined") -- Regards Frank Kabel Frankfurt, Germany "govworker" schrieb im Newsbeitrag ... How do I get excel to search through a range of numbers for example the equation that I would like to complete is IF(B5=1.99 - 1.5,10) but excell thinks that 1.99 - 1.5 is 1.99 minus 1.5. Please help. Matthew |
|
#3
|
|||
|
|||
|
Thank you for your help. It worked great.
"Frank Kabel" wrote: Hi =IF(AND(B5=1.5,B5<=1.99),10,"not defined") -- Regards Frank Kabel Frankfurt, Germany "govworker" schrieb im Newsbeitrag ... How do I get excel to search through a range of numbers for example the equation that I would like to complete is IF(B5=1.99 - 1.5,10) but excell thinks that 1.99 - 1.5 is 1.99 minus 1.5. Please help. Matthew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Windows search in Excel with autofilter | Excel Discussion (Misc queries) | |||
| Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
| How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
