Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2734168%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734168%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20time%20for%20example%20a%20number%20in%20C4%20(like%203.597%2C00)%20and%20in%20D4%20(x%208.692%2C05).%20Now%20I%20need%20to%20get%20to%20the%20result%20in%20F4%20but%20I%20don't%20want%20to%20type%20(%3D3.597*8.692%2C05).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20there%20is%20a%20formula%20or%20a%20way%20that%20will%20see%20the%20x%20as%20an%20*.%20But%20I%20sadly%20forgot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20is%20there%20a%20way%20to%20do%20the%20same%20thing%20with%20the%20devision%3F%26nbsp%3BC4%20(like%203.597%2C00)%20and%20in%20D4%20(%2F%208.692%2C05)%20to%20get%20the%20result%20and%20not%20having%20to%20type%26nbsp%3B(%3D3.597%2F8.692%2C05)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%20(BTW%20English%20is%20not%20my%20first%20language%2C%20so%20I'm%20sorry%20if%20I%20made%20errors)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2734168%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2734209%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150352%22%20target%3D%22_blank%22%3E%40Kathariena_1984%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20478px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309084iFADD737C92CEBF11%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eit%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIFERROR(%20CHOOSE(%20(%20LEFT(D4)%3D%22x%22)%20%2B%20(LEFT(D4)%3D%22%2F%22)*2%2C%20C4*RIGHT(D4%2C%20LEN(D4)-1)%2C%20C4%2FRIGHT(D4%2C%20LEN(D4)-1)%20%20)%2C%20%22wrong%20data%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2734219%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734219%22%20slang%3D%22en-US%22%3EThe%20result%20is%20indeed%20what%20I'm%20trying%20to%20get%2C%20but%20I%20don't%20remember%20that%20the%20formula%20was%20so%20long%20and%20complicated.%20But%20thank%20you%20anyway.%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

 

You time for example a number in C4 (like 3.597,00) and in D4 (x 8.692,05). Now I need to get to the result in F4 but I don't want to type (=3.597*8.692,05).

 

I know there is a formula or a way that will see the x as an *. But I sadly forgot.

 

And is there a way to do the same thing with the devision? C4 (like 3.597,00) and in D4 (/ 8.692,05) to get the result and not having to type (=3.597/8.692,05)

 

Thank you in advance. (BTW English is not my first language, so I'm sorry if I made errors)

 

 

5 Replies

@Kathariena_1984 

If like this

image.png

it could be

=IFERROR( CHOOSE( ( LEFT(D4)="x") + (LEFT(D4)="/")*2, C4*RIGHT(D4, LEN(D4)-1), C4/RIGHT(D4, LEN(D4)-1)  ), "wrong data")

 

The result is indeed what I'm trying to get, but I don't remember that the formula was so long and complicated. But thank you anyway.

@Kathariena_1984 

You could do the following:

In E4, enter the formula =C4*D4

Select F4.

On the Formulas tab of the ribbon, select Define Name.

In the Name box, enter Eval

In the Refer to box, enter the formula =EVALUATE(Sheet2!E4)

Click OK.

Enter the following formula in F4:  =Eval

This can be filled down if necessary.

 

S0748.png

Heeft u die formule toevallig ook in het Nederlands?

@Kathariena_1984 

EVALUATE is een oude Excel 4.0 macro-functie die alleen werkt in een gedefinieerde naam. Ik weet eerlijk gezegd niet of de functie in de Nederlandse versie is vertaald of niet.

Probeer daarom zowel EVALUATE als EVALUEREN en kijk of het werkt.