Thread: IF Fomula
View Single Post
  #1   Report Post  
DWadding
 
Posts: n/a
Default 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