Excel - IF Function Problem - Expert Solution

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

I have a spreadsheet with IF Statements in multiple cells of a single row entry. I need to be able to allow... I'm not seeing a download button to grab the spreadsheet....
Solved by O. H. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/12/2016 - 06:07
Hello, Welcome to Excel chat.
User 14/12/2016 - 06:07
I had a session going but was unable to download the updated spreadsheet. Where you the one working with me on that?
Excelchat Expert 14/12/2016 - 06:07
yes
Excelchat Expert 14/12/2016 - 06:07
one of our co-representative
Excelchat Expert 14/12/2016 - 06:08
I have your file, let me just upload it for you
User 14/12/2016 - 06:10
ty
Excelchat Expert 14/12/2016 - 06:11
are you able to download it now?
[Uploaded an Excel file]
Excelchat Expert 14/12/2016 - 06:14
Just checking, did you get the file now?
User 14/12/2016 - 06:16
yes, and saved it as xlsm but the button is not working
Excelchat Expert 14/12/2016 - 06:16
can you just try as it is, without changing the extension
User 14/12/2016 - 06:18
button still not working
Excelchat Expert 14/12/2016 - 06:18
Please give me a moment, let me check
Excelchat Expert 14/12/2016 - 06:19
are macros enabled on your PC?
User 14/12/2016 - 06:19
yes
Excelchat Expert 14/12/2016 - 06:20
can you try one more time, by closing the file and reopening it, or you can try running the macro directly from Developer Tab
User 14/12/2016 - 06:20
there are no macro names to select.
Excelchat Expert 14/12/2016 - 06:21
our supervisor will be emailing the file directly to you
Excelchat Expert 14/12/2016 - 06:22
he already emailed it, can you please check your mail inbox
Excelchat Expert 14/12/2016 - 06:22
it should be from tyler@gotitapp.co
User 14/12/2016 - 06:23
checking
Excelchat Expert 14/12/2016 - 06:23
ok
Excelchat Expert 14/12/2016 - 06:25
did you find it?
User 14/12/2016 - 06:29
it's not letting me log into my account
Excelchat Expert 14/12/2016 - 06:29
our supervisor has send an email to your registered email id, are you not able to access your email
User 14/12/2016 - 06:30
correct, can yoiu send it to my other email acct? benton64djb@yahoo.com
Excelchat Expert 14/12/2016 - 06:30
alternatively, here is another file, here you don't have tp create a new row, the formulas are already applied, as soon as you enter a value in cell B, all the values will be automatically filled in
Excelchat Expert 14/12/2016 - 06:31
sent to the email you just gave
[Uploaded an Excel file]
Excelchat Expert 14/12/2016 - 06:33
only about 3 minustes remaining in this session, please repost and we will be here to help you
User 14/12/2016 - 06:35
awesome, where is the logic for that at in the xls?
Excelchat Expert 14/12/2016 - 06:35
did you get the email from our supervisor containing the macro file?
Excelchat Expert 14/12/2016 - 06:35
the one without the macro?
User 14/12/2016 - 06:35
yes
Excelchat Expert 14/12/2016 - 06:36
its only the formulas
Excelchat Expert 14/12/2016 - 06:36
not the macro
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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc