Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
=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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
=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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formulas
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formulas | Excel Worksheet Functions | |||
Conditional formulas | Excel Discussion (Misc queries) | |||
Conditional use of formulas | Excel Worksheet Functions | |||
Conditional Formulas | Excel Worksheet Functions | |||
Conditional Formulas Maybe? | Excel Discussion (Misc queries) |