Discussion Excel Formula in IT Resources & Training
https://techcommunity.microsoft.com/t5/it-resources-training/excel-formula/m-p/1230863#M520
<P>Hy i want to make a sheet in which just separate two values</P><P>example</P><P>if a value written in cell e1-f1 is equal to 15 or less then 15 then * 10 and remaining be * 20</P><P> it should be shown in to two different cells</P><P>50-30=20 but first 15*10 and remaining 5 should *20</P><P>please</P><P> </P>Mon, 16 Mar 2020 15:14:44 GMTlife_for_learn2020-03-16T15:14:44ZExcel Formula
https://techcommunity.microsoft.com/t5/it-resources-training/excel-formula/m-p/1230863#M520
<P>Hy i want to make a sheet in which just separate two values</P><P>example</P><P>if a value written in cell e1-f1 is equal to 15 or less then 15 then * 10 and remaining be * 20</P><P> it should be shown in to two different cells</P><P>50-30=20 but first 15*10 and remaining 5 should *20</P><P>please</P><P> </P>Mon, 16 Mar 2020 15:14:44 GMThttps://techcommunity.microsoft.com/t5/it-resources-training/excel-formula/m-p/1230863#M520life_for_learn2020-03-16T15:14:44Z