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

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

Highlighted

@PReagan 

It kicked back #VALUE

@Buckeye55 

 

I fixed it. 

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies