Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A formula query please

Status
Not open for further replies.
sooze29

sooze29

Instructor
May 12, 2006
54
GB
I am trying to do the following and getting an error message, I am guessing brackets in the wrong place but am completely stumped. Can anyone help please?

=D6-(D10:D12)
 
Sort by date Sort by votes
It depends on what the error message actually is ... care to enlighten us all?

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Upvote 0 Downvote
Actually I have figured it out, someone had given me wrong information. The formula was =D6-SUM(D10:D12). So we had a figure and we wanted to know what it would be minus range, but they had sort of told me back to front :)
 
Upvote 0 Downvote
I should have spotted that, but without knowing the actual error message, I didn't even look ( always give full information in a posting ). I'm glad you figured it out :)

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
324
SkipVought
S
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
746
SoftwareRT
SoftwareRT
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
277
combo
combo
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
189
TomSalvato
TomSalvato
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
233
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top