Home

Need assistance with an If Then formula

%3CLINGO-SUB%20id%3D%22lingo-sub-765227%22%20slang%3D%22en-US%22%3ENeed%20assistance%20with%20an%20If%20Then%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765227%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20the%20following%20to%20occur.%20When%20I%20pick%20say%2022%20inches%20from%20a%20drop%20down%20I%20want%20to%20display%20that%20result%20in%20the%20cell%20with%20the%20drop%20down%20but%20then%20display%20the%20conversion%20to%20centimeters%20in%20the%20cell%20directly%20below%20the%20cell%20displaying%2022%20inches.%20The%20drop%20downs%20are%20already%20created%20for%20inches%20and%20centimeters%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-765227%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765251%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assistance%20with%20an%20If%20Then%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765251%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379200%22%20target%3D%22_blank%22%3E%40Buckeye55%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20say%20your%20drop-down%20is%20located%20in%20cell%20A1%2C%20then%20in%20cell%20A2%20put%20the%20following%3A%3C%2FP%3E%3CP%3E%3DCONVERT(A1%2C%22in%22%2C%22cm%22)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765361%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assistance%20with%20an%20If%20Then%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20kicked%20back%20%23VALUE%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765362%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assistance%20with%20an%20If%20Then%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379200%22%20target%3D%22_blank%22%3E%40Buckeye55%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20fixed%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Buckeye55
New Contributor

I want the following to occur. When I pick say 22 inches from a drop down I want to display that result in the cell with the drop down but then display the conversion to centimeters in the cell directly below the cell displaying 22 inches. The drop downs are already created for inches and centimeters

3 Replies
Highlighted

Hello @Buckeye55,

 

Let's say your drop-down is located in cell A1, then in cell A2 put the following:

=CONVERT(A1,"in","cm") 

 

Hope this helps!
PReagan

@PReagan 

It kicked back #VALUE

@Buckeye55 

 

I fixed it. 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies