IF Fomula

[Guest]

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(A10>500),"???","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+B10>500),"???","0", but again I don't know what to put into the ???
section.

I hope this make some sence to someone.

DW

 

[Guest]

Maybe you're looking for something such as the following:

IF(C11>500,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