Microsoft Office Forums - View Single Post - [Solved] How make IF Formula return a numbers joined with a letter

Thread: [Solved] How make IF Formula return a numbers joined with a letter

View Single Post

Old

01-07-2019, 03:13 PM

Strogg

Strogg is offline

Strogg uses Windows 7 32bit

Windows 7 32bit Strogg uses Office 2016

Strogg uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jan 2019

Posts: 9

Strogg is on a distinguished road

Default

Quote:

Originally Posted by macropod

View Post

For that you could use a formula coded as:
{IF{=A1}= 0 "" {=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"}}

I think I finally learned it. Thank you!

Reply With Quote