Is SUMIF the answer

[deanNYC]

Morning,
I am trying to create a formula that will minus F51 by B59 if D59 =P, i have tried formula =SUMIF(D59,"P",F51-B59) but this creates an error. I am thinking SUMIF is not the correct formula I need to use as I am trying to subtract. Can any kind person please help me resolve this please?

My spreadsheet is my monthly outgoings which are 90% static the one I am trying to use a formula with is a debt which reduces on every payment till full payment is paid. That is what i want to display, how much left I have to pay.

 

[FormR]

Hi, you just need to use an IF() function - you didn't say what should happen when D59 is not P - this just returns F51.

=IF(D59="P",F51-B59,F51)

 

[James006]

Hi,

Is the following formula of any help :

=f51-If(d59="P",b59,0)

 

[deanNYC]

Thank you both.
I now have 2 options, both display what I was hoping for. ...

 

[James006]

You are welcome ... :wink: