# Calculating and showing a negative number

#### KC*3

##### New Member
Hi there everyone!

I need to figure out how to show the diffence between 2 numbers.

Example:

Hours BID = 50.00 hours
Hours Used = 53.00 hours
Difference = -(3.00) hours
% of hours BID = -(6%)

If at all possible I'd like the negative numbers to appear in a Red font too. But that is not crucial at this point.

I'd also like to know how to do this for dates.

Example:
Difference = -(2) days

If any of you know how to do this that would be so great! Thanks.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Please forgive me if my reply seems insulting. (You must be asking for something more than a simple subtraction formula but I don't know what that might be).

since you didn't indicate cells, the formula in English is:
=Used-Bid (For the difference)
=Used/Bid (for percent)

Same idea for your days calc

nbrcrunch is almost right.

I think you want the following expressions.

[Hours BID]-[Hours Used]

([Hours BID]-[Hours Used])/[Hours BID]

To get the required formats use Format(<expression>, <format>)

As for the dates you could just subtract one from the other, but I'm a little bit unclear what you mean by negative days.

Totally not insulting because I should have been more specific. I do know the calculation and entering that in to the query is not a problem.

The real issue is when it comes to showing that it is a negative number. I have not been able to find a way to get access to show this as negative, it still shows as positive numbers.

Sorry for my confusion ; )

Katrina

The negative days is only meant to say that the first task listed was completed after the second task listed. So I would want to show the interval as -2 days.

Katrina

Katrina

If the result of the calculation is negative then Access should show it like that.

If you are referring to the () then you would need to do some formatting for that.

Replies
5
Views
1K
Replies
12
Views
2K
Replies
0
Views
202
Replies
2
Views
407
Replies
2
Views
281

1,203,171
Messages
6,053,878
Members
444,692
Latest member
Queendom

### 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.

### Which adblocker are you using?

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

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