Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |