Data Import From Web - Question

Joneye

Joneye

Well-known Member
Joined
May 28, 2010
Messages
777
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
Im simply trying to subtract one figure from the other and getting an error, can some advise is it cell formatting? Or suggest how I can beat the #VALUE! issue?

As always many thanks



Excel 2012
BCDEF
3BackersCurrently PledgedTo TargetDays to GoRequired
487$5,373#VALUE!26$40,000
Sheet2
Cell Formulas
RangeFormula
B4=Sheet1!A137
C4=Sheet1!A140
D4=SUM(C4-F4)
E4=Sheet3!$F$2
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Question
Mock Finance sheet
Replies
3
Views
62
Marvo
M
A
  • Question
Import Table Data from Web using VBA to excel Worksheet and able to input Values which can modify the web data to be extract
Replies
0
Views
358
Ambrosia
A
N
  • Question
VBA Questions - Copying dynamic data from one tab to another and deleting filtered rows
Replies
1
Views
185
DanteAmor
DanteAmor
C
  • Question
VBA-Photos to be imported from Sharepoint Site rather than local drive
Replies
1
Views
165
Micron
M
M
  • Solved
How to sum a row of data with some cells containing an extra character
2
Replies
10
Views
699
Fluff
Fluff

Forum statistics

Threads
1,214,970
Messages
6,122,514
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top