Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and N12
are simply input numbers.

=if(I12N12,J12=(N12-D12),J12=(I12-D12))

"Danno" wrote:

Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and N12
are simply input numbers.

Hi Danno

In cell J12 enter
=IF(I12N12,N12-D12,I12-D12)

You don't say what you want to happen if I12=N12.
You could change the above to
=IF(I12=N12,N12-D12,I12-D12)
which would make the result N12-D12 if I12=N12

If on the other hand, you wanted a different result altogether if they were
equal, then you would have to use
=IF(I12N12,N12-D12,IF(I12<N12,I12-D12,"something else"))
replace "something else" with the result you want to see.
--
Regards
Roger Govier

"Danno" wrote in message
...
Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and
N12
are simply input numbers.

Thanks, but that just returns "FALSE" and doesn't do the calculations.

"JasonP CCTM LV" wrote:

=if(I12N12,J12=(N12-D12),J12=(I12-D12))

"Danno" wrote:

Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and N12
are simply input numbers.

=if(I12N12,N12-D12,I12-D12)

I assume you put J12 there because that is where you put this formula

--


Regards,


Peo Sjoblom

"Danno" wrote in message
...
Thanks, but that just returns "FALSE" and doesn't do the calculations.

"JasonP CCTM LV" wrote:

=if(I12N12,J12=(N12-D12),J12=(I12-D12))

"Danno" wrote:

Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12
and N12
are simply input numbers.

=MIN(I12,N12)-D12
--
David Biddulph

"Danno" wrote in message
...
Anyone know how to write a formula for this?

IF(I12N12) then J12=(N12-D12) but if(I12<N12) then J12=(I12-D12)

where I12 is derived from another formula (=SUMC12+M12) and C12, M12 and
N12
are simply input numbers.