Answer the question
In order to leave comments, you need to log in
A
A
arsenaljek2020-08-11 09:11:46
arsenaljek, 2020-08-11 09:11:46
Why is the EXCEL formula not working?
Why doesn't the formula work on the "Price tags" sheet?
spoiler
The first position "picks up" everything correctly, and all subsequent ones do not work.
1 answer(s)
@arsenaljek
Change the cells to General ( General ? ) then double-click on the cell and press Enter
And also in the error formulas? =Inventory of _ goods!H8 / ='Inventory of goods'!H9 there is no underscore.
PS: do not upload files with macros, it is better to make a copy of the file and delete them and upload them that way. security and all.
D
datka, 2020-08-11 @arsenaljek
Everything is simple. You have a cell in text format, so the formula is not displayed.
spoiler
Change the cells to General ( General ? ) then double-click on the cell and press Enter
And also in the error formulas? =Inventory of _ goods!H8 / ='Inventory of goods'!H9 there is no underscore.
PS: do not upload files with macros, it is better to make a copy of the file and delete them and upload them that way. security and all.
Similar questions
C
S
A
H
O
OlyaL2015-05-29 12:01:32
Why doesn't Xls print the selected page range at the bottom of the sheet?
1Reply
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question