| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula using non-literal values
I have defined a formula that tests the value in 3 columns. If the value in
each column passes the test, the formula calculates a value for another column. e.g. =IF(AND(I7<750,J7<100,K7<50000),C7*0.06,"0") I've noticed that if the value of the column being tested contains a value symbol (< or ), the formula does not calculate. It appears the formula requires a literal value ("10" vs. "<10"). Is there a way around this? Thank you for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number to words literal | Excel Worksheet Functions | |||
| Literal quotation marks retained from a formula | Excel Discussion (Misc queries) | |||
| How to use literal quotes with concatenation | Excel Discussion (Misc queries) | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| Referencing Literal Arrays | Excel Worksheet Functions | |||
Threaded Mode
