Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1230863%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1230863%22%20slang%3D%22en-US%22%3E%3CP%3EHy%20i%20want%20to%20make%20a%20sheet%20in%20which%20just%20separate%20two%20values%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3Eif%20a%20value%20written%20in%20cell%20e1-f1%20is%20equal%20to%2015%20or%20less%20then%2015%20then%20*%2010%20and%20remaining%20be%20*%2020%3C%2FP%3E%3CP%3E%26nbsp%3Bit%20should%20be%20shown%20in%20to%20two%20different%20cells%3C%2FP%3E%3CP%3E50-30%3D20%20but%20first%2015*10%20and%20remaining%205%20should%20*20%3C%2FP%3E%3CP%3Eplease%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hy i want to make a sheet in which just separate two values

example

if a value written in cell e1-f1 is equal to 15 or less then 15 then * 10 and remaining be * 20

 it should be shown in to two different cells

50-30=20 but first 15*10 and remaining 5 should *20

please

  

0 Replies