# Need some help with a calculation

#### calmedic21

##### New Member
Hello,

I am new to this site. I am not very good at Excel 2003, but I am learning. I have actually created some accounting forms for my neighbor who I am helping and need some help on one of them. Is there a way to have someone help me by seeing the actual spreadsheet?

Frank

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

#### Joe4

Welcome to the Board!

Try posting some images of sample data to the board. There are tools to assist you in that endeavour. Some can be found in the About This Board forum. Richard Schollar also has a tool you can use if you send him a Private Message. You can see his profile here.

#### calmedic21

##### New Member
Hi Joe,

Thank you so much for your reply. Again, please forgive me, I am new to this forum type stuff. How do I attach a copy of the worksheet I need help on?

Thanks Again.

#### Joe4

You CANNOT attach your worksheet, only images.
I mentioned in my last post how you can find out information on how to do that, and provided a link to a Moderator on this board who can send you a program he has to do that.

#### calmedic21

##### New Member

Great...Thank You

#### calmedic21

##### New Member
This is what I am trying to accomplish:

E5=Service Amt
F5=Repair Amt
G5=Total Amt of E5 + F5
H5=Discount Total E5 + F5 - 3%
Q5=Balance
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
If customer pays before end of month, they pay the discounted amt on the invoice, which is Column H5, if they do not, they pay the original amount which is Column G5. I need a formula to tell the Balance Column Q5 which Total to use. Each Row is a customer. Maybe like adding a Checkbox Column that if it is checked use one or the other.

#### Joe4

You could use Data Validation to make a drop down selection to indicate if they paid early or not (Yes/No), or prehaps enter the dates.

Then you could just use a simple IF statement to determine which value to return, i.e.

=IF(I5="Yes",H5,G5)

#### calmedic21

##### New Member
Hello Joe,

That worked great. But I forgot to tell you that Cells L5 and O5 is where I enter the amount the customer paid by check. Two cells in case they pay by two checks. So when I enter the amounts, the Balance does not go down. But the formula you gave me works awesome.

#### Joe4

You could just subtract those amounts, if that is what you want to happen.

=IF(I5="Yes",H5,G5) - L5 - O5

#### calmedic21

##### New Member
Outstanding! Job well done. Many thanks to you my friend.

Replies
12
Views
902
Replies
0
Views
59
Replies
4
Views
473
Replies
2
Views
119
Replies
3
Views
221

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,575
Messages
5,832,576
Members
430,142
Latest member
ivonsurf123

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