Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Fomula
I would like to add a formula that contains an IF statement
I have a bill due when the liability equals over $500. I have columns for each bill and a row totaling the due for that bill, where I would like the next row down to be the amount due, when over $500. Here is an example Bue this bill A10:250.00 B10:100.00 C10: 175.00 So I would like row 11 to look like this A11:$0 B11: $0 C11 $525.00 I know that I can have the formula for A11 =IF(A10500),"???","0" and it will put the 0 for nothing due, but I don't know what to put in the ??? section to get it to pull the A10 if A10 over 500. I think the formula for B11 would look something like =IF(A10+B10500),"???","0", but again I don't know what to put into the ??? section. I hope this make some sence to someone. DW |
#2
|
|||
|
|||
Maybe you're looking for something such as the following:
IF(C11500,C11-500,0) This formula checks cell C11 and if the value is greater than 500, it will return the cell value less 500, else it will return zero. Hope this helps! -Chad "DWadding" wrote: I would like to add a formula that contains an IF statement I have a bill due when the liability equals over $500. I have columns for each bill and a row totaling the due for that bill, where I would like the next row down to be the amount due, when over $500. Here is an example Bue this bill A10:250.00 B10:100.00 C10: 175.00 So I would like row 11 to look like this A11:$0 B11: $0 C11 $525.00 I know that I can have the formula for A11 =IF(A10500),"???","0" and it will put the 0 for nothing due, but I don't know what to put in the ??? section to get it to pull the A10 if A10 over 500. I think the formula for B11 would look something like =IF(A10+B10500),"???","0", but again I don't know what to put into the ??? section. I hope this make some sence to someone. DW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To copy fomula | Excel Worksheet Functions | |||
stop automatically changing fomula ... | Excel Worksheet Functions | |||
Viewing the whole path and not the fomula | Excel Discussion (Misc queries) | |||
To get fomula to display a Zero | Excel Discussion (Misc queries) | |||
How to get cell value with the ID from a fomula? | Excel Discussion (Misc queries) |