# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, we like to upload our spreadsheets o(or extract them) nline and we were wondering if this was possible? How much memory can excel online take? does it tend to slow the laptop down? can formulas be used on excel online as well?
Solved by O. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/01/2018 - 11:57
Hello
Excelchat Expert 29/01/2018 - 11:58
User 29/01/2018 - 11:58
ok
Excelchat Expert 29/01/2018 - 11:58
ot to dropbox and share the link with me
User 29/01/2018 - 11:58
User 29/01/2018 - 11:58
ok will do
User 29/01/2018 - 12:02
https://edelmanftp.box.com/s/xph5tgh0f6sb03b3s185nbzyvx4weoek
User 29/01/2018 - 12:02
try this
Excelchat Expert 29/01/2018 - 12:04
User 29/01/2018 - 12:05
ojk
User 29/01/2018 - 12:05
it takes a while
User 29/01/2018 - 12:05
so if you can let me know if it can be uploaded on excel online
Excelchat Expert 29/01/2018 - 12:06
opening now
User 29/01/2018 - 12:06
and if the information from each market countries (can be extracted to automatically create formulas)
User 29/01/2018 - 12:06
as we tend to do it manually
User 29/01/2018 - 12:06
which takes a LOT of time
Excelchat Expert 29/01/2018 - 12:07
Excelchat Expert 29/01/2018 - 12:07
User 29/01/2018 - 12:08
how can we upload this doc online
User 29/01/2018 - 12:08
to excel online
User 29/01/2018 - 12:10
2) we usually input markets manually - is there a way we can have different tabs for each market and use them to create formulas for month by market
Excelchat Expert 29/01/2018 - 12:11
You can do next
Excelchat Expert 29/01/2018 - 12:11
to create separate excel files
Excelchat Expert 29/01/2018 - 12:11
for each
Excelchat Expert 29/01/2018 - 12:11
markets
Excelchat Expert 29/01/2018 - 12:11
then create 1 main excel file
Excelchat Expert 29/01/2018 - 12:12
and put a macro code in it
Excelchat Expert 29/01/2018 - 12:12
then press the button to consolidate all data in together
Excelchat Expert 29/01/2018 - 12:12
this is the best way
Excelchat Expert 29/01/2018 - 12:12
otherwise it will work slow even online
Excelchat Expert 29/01/2018 - 12:13
because each time it will recalculate everything..
User 29/01/2018 - 12:13
will pivot tables help?
Excelchat Expert 29/01/2018 - 12:13
No Pivot tables also load the file
Excelchat Expert 29/01/2018 - 12:13
really this is not a solution
User 29/01/2018 - 12:13
User 29/01/2018 - 12:13
like with the macro code
Excelchat Expert 29/01/2018 - 12:13
the best way
Excelchat Expert 29/01/2018 - 12:14
is VBA (Visual Basic Application) = Macro coding
Excelchat Expert 29/01/2018 - 12:14
yes
Excelchat Expert 29/01/2018 - 12:14
you can also to repost your question here
Excelchat Expert 29/01/2018 - 12:14
please mention the right type (VBA, but nor fixing formulas, other, pivot tables or etc.)
Excelchat Expert 29/01/2018 - 12:14
put VBA
Excelchat Expert 29/01/2018 - 12:15
Excelchat Expert 29/01/2018 - 12:15
or you can search in google and try to make it
Excelchat Expert 29/01/2018 - 12:15
u just need to separate this big file to markets
Excelchat Expert 29/01/2018 - 12:15
that's all
Excelchat Expert 29/01/2018 - 12:15
then consolidate using Macro
User 29/01/2018 - 12:15
ok got ya

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.