Beyond my knowledge or impossible please help

[NialithGodSlayer]

I will explain the cells first
A1 = a set value (5700)
B1 = deducted value
C1 = cost
D1 = a different deducted value

So i want B1 to be A1-C1 but if the value of C1 is 0 then could i instead get b1 to equal the value of D1 if the value of D1 is less than the value of A1

 

[Fluff]

How about

=IF(C1<>0,A1-C1,IF(D1=0,A1,D1))

 

[joeu2004]

How about
=IF(C1<>0,A1-C1,IF(D1=0,A1,D1))

Did you test that with the 3rd example in the image, where B1=0 when A1=5700, C1=0, D1=0?(!)

Did you notice that NGS's latest conditions have nothing to do with C1?(!) They are all of the form "if the value of b1...".

And if you believe that is just a typo and "if...b1" was meant to be "if...c1", how do reconcile the first two "if..." statements?

Food for thought. Gave me indigestion.

 

[Fluff]

Did you test that with the 3rd example in the image,

No, I just went by the previous post from the OP.

 

[NialithGodSlayer]

No, I just went by the previous post from the OP.

so i figured its something like this after a lot of testing, i just need to be able to write it to work together

=IF(C40>0,E40,I40+J40=IF(I40=0,K40+J40=IF(J40=0,L40+I40=IF(I40+J40=0,M40,E40))))

 

[NialithGodSlayer]

so i figured its something like this after a lot of testing, i just need to be able to write it to work together

=IF(C40>0,E40,I40+J40=IF(I40=0,K40+J40=IF(J40=0,L40+I40=IF(I40+J40=0,M40,E40))))

so its
=if(c40>0,e40,i40+j40)
but if i40=0
then replace with the last bit with
k40+j40
or if j40=0
then replace with the las bit with
l40+i40
or if i40+j40=0
then replace the last bit with
m40

im not even sure its possible