Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With A Formula Please
I guess I did not make myself clear in my original post. I need a formula
that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF formula it comes back FALSE. This is for a cash over/under formula. For instance when you take in money at a restaurant, you find your cash over/under by totaling the sales receipts minus the credit card amounts. After you remove you starting amount of cash (cash drawer) from the total cash you have, if the remaining cash does not equal that amount you have a cash over/short. I need a formula that calculates this. A being the amount of cash you should have and B being the amount you actually have. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With A Formula Please
Surely it is just
B1-A1 or if you want a message =IF(B1-A1=0,"No problem","Problem") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Autumn Dreams" wrote in message ... I guess I did not make myself clear in my original post. I need a formula that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF formula it comes back FALSE. This is for a cash over/under formula. For instance when you take in money at a restaurant, you find your cash over/under by totaling the sales receipts minus the credit card amounts. After you remove you starting amount of cash (cash drawer) from the total cash you have, if the remaining cash does not equal that amount you have a cash over/short. I need a formula that calculates this. A being the amount of cash you should have and B being the amount you actually have. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With A Formula Please
Autumn Dreams Wrote: I guess I did not make myself clear in my original post. I need a formula that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF formula it comes back FALSE. does this work won't you always end up with a neg number? Besides you are asking the same thing but want different results if A1=B1 then A1-B1 if A1=B1 then B1-A1 How can this happen?? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=537159 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With A Formula Please
Thank you, but that only reflects one of the answers I need. If I do 2
columns with B1-A1 and the other A1-B1, I get to different answers showing at the same time. I need just one answer or zero to indicate they are equal. ie If B is greater than A it's a positive (overage), if B is less than A it's a negative (shortage). Hope this explains what I need better. Thank you. "Bob Phillips" wrote: Surely it is just B1-A1 or if you want a message =IF(B1-A1=0,"No problem","Problem") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Autumn Dreams" wrote in message ... I guess I did not make myself clear in my original post. I need a formula that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF formula it comes back FALSE. This is for a cash over/under formula. For instance when you take in money at a restaurant, you find your cash over/under by totaling the sales receipts minus the credit card amounts. After you remove you starting amount of cash (cash drawer) from the total cash you have, if the remaining cash does not equal that amount you have a cash over/short. I need a formula that calculates this. A being the amount of cash you should have and B being the amount you actually have. Thank you. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With A Formula Please
Why do it twice? Obviously 11-10 is different to 10-11, it is a different
sum so it gives a different result. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Autumn Dreams" wrote in message ... Thank you, but that only reflects one of the answers I need. If I do 2 columns with B1-A1 and the other A1-B1, I get to different answers showing at the same time. I need just one answer or zero to indicate they are equal. ie If B is greater than A it's a positive (overage), if B is less than A it's a negative (shortage). Hope this explains what I need better. Thank you. "Bob Phillips" wrote: Surely it is just B1-A1 or if you want a message =IF(B1-A1=0,"No problem","Problem") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Autumn Dreams" wrote in message ... I guess I did not make myself clear in my original post. I need a formula that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF formula it comes back FALSE. This is for a cash over/under formula. For instance when you take in money at a restaurant, you find your cash over/under by totaling the sales receipts minus the credit card amounts. After you remove you starting amount of cash (cash drawer) from the total cash you have, if the remaining cash does not equal that amount you have a cash over/short. I need a formula that calculates this. A being the amount of cash you should have and B being the amount you actually have. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |