Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula result is not displaying
I have a formula that is working. But in the cell that the formula is applied
to, it displays #N/A. When I go to the formula wizard it's displaying the correct result. Any help would be greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula result is not displaying
Perhaps you could let us know what formula you are using ... ?
Pete Olga wrote: I have a formula that is working. But in the cell that the formula is applied to, it displays #N/A. When I go to the formula wizard it's displaying the correct result. Any help would be greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula result is not displaying
Sure. Here it is:
=INDEX('formatted sheet'!K1:K14,MATCH(1,('formatted sheet'!H1:H100='Mason Road'!D4)*('formatted sheet'!J1:J100='Mason Road'!A39),0)) "Pete_UK" wrote: Perhaps you could let us know what formula you are using ... ? Pete Olga wrote: I have a formula that is working. But in the cell that the formula is applied to, it displays #N/A. When I go to the formula wizard it's displaying the correct result. Any help would be greatly appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula result is not displaying
I figured it out. :) I forgot to enclose the formula in { }.
"Olga" wrote: I have a formula that is working. But in the cell that the formula is applied to, it displays #N/A. When I go to the formula wizard it's displaying the correct result. Any help would be greatly appreciated! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula result is not displaying
This is an array formula - you must commit it with CTRL-SHIFT-ENTER
(CSE) rather than just ENTER. Click in the formula bar as if to edit the formula, then do CSE - if you do this correctly then Excel will wrap curly braces { } around the formula when viewed in the formula bar: you must not type these yourself. Hope this helps - somewhat delayed, but Google Groups has been down today. Pete Olga wrote: Sure. Here it is: =INDEX('formatted sheet'!K1:K14,MATCH(1,('formatted sheet'!H1:H100='Mason Road'!D4)*('formatted sheet'!J1:J100='Mason Road'!A39),0)) "Pete_UK" wrote: Perhaps you could let us know what formula you are using ... ? Pete Olga wrote: I have a formula that is working. But in the cell that the formula is applied to, it displays #N/A. When I go to the formula wizard it's displaying the correct result. Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |