Excel Formel

%3CLINGO-SUB%20id%3D%22lingo-sub-2697622%22%20slang%3D%22de-DE%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697622%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%2C%20I%20am%20looking%20for%20a%20formula%20with%20which%20I%20can%20calculate%20hail%20damage.%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20Field%20B1%20stands%20for%20number%20of%20dents%201-400%3C%2FP%3E%3CP%3EField%20C1%20stands%20for%20dent%20size%2020mm%3C%2FP%3E%3CP%3EField%20D1%20returns%20the%20work%20value%3C%2FP%3E%3CP%3EExample%20B1%3D1%20C1%3D20%20D1%3D6%3C%2FP%3E%3CP%3EB1%3D2%20C1%3D20%20D1%3D8%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20formula%20can%20I%20take%20does%20anyone%20have%20any%20advice%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreetings%20Chris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2697622%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697650%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697650%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1140511%22%20target%3D%22_blank%22%3E%40Handmade%3C%2FA%3E%26nbsp%3BPerhaps%26nbsp%3B%3CEM%3E%3CSTRONG%3E%3DB1*C1*D1%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hallo, ich suche eine Formel zur womit ich Hagelschäden kalkulieren kann. 

Beispiel Feld B1 steht für Dellenanzahl  1-400

             Feld C1 steht für Dellengröße  20mm

             Feld D1 gibt den Arbeitswert wieder 

Beispiel B1=1  C1=20  D1=6

             B1=2  C1=20  D1=8

 

Welche Formel kann ich nehmen hat jemand einen Rat?

 

Grüße Chris

1 Reply

@Handmade Perhaps =B1*C1*D1