can these two formulas be combined??

[Dylan driscoll]

Formula1: =G3/(A3-0.58)
formula2: =IF(AND(M3=0),0,IF(AND((M3-S3)*(A3-0.58)<0),0,(M3-S3)*(A3-0.58)))

In formula 2 the result of formula 1 is the M3

 

[dave3009]

Try this

=IF((G3/(A3-0.58))=0,0,IF((G3/(A3-0.58)-S3)*(A3-0.58)<0,0,((G3/(A3-0.58))-S3)*(A3-0.58)))

HTH

 

[Dylan driscoll]

It worked...thank you