| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula not working as the result of a previous formula?
Formula is =IF(AND(E133="Liss", ISNUMBER(G133)), F133, "0"), where
F133 is the result of its own formula. So far I'm just getting "0" for this, even though otherwise the criteria for the formula are met. Is that because F133 is the result of its own formula? If so, is there anything I can do about it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
![Ed[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
