| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement with Sum
Thank you... It worked...
-- -Chip =) "via135" wrote: hi! =IF(B1<A1,"",IF(B1A1,MIN(B1-A1,C1),"")) -via135 Chip1035 Wrote: I did not know how to search for this, so my apologies if it has been posted before. A1 | B1 | C1 | D1 $20 $35 $5 $5 I have in A1, $20 allowed, B1 has $35 used, C1 is $5 left over from previous month What I want D1 to have is the amount over what was allowed in A1 but not to exceed what is in C1. Also, if B1 does not exceed A1, then D1 should be blank. So far I came up with this IF(G6E6,G6-E6,"") which would get me 15, which is over C1. If it is over C1, I want it to equal C1. I tried this: IF(B1A1,(SUM(B1-A1)C1,C1),"") but got an #VALUE! error. Thank you for any and all assistance, in advance. -- -Chip =) -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=522308 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| Long IF Statement | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
Threaded Mode
