Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-06-2019, 01:46 PM
Strogg Strogg is offline How make IF Formula return a numbers joined with a letter Windows 7 32bit How make IF Formula return a numbers joined with a letter Office 2016
Novice
How make IF Formula return a numbers joined with a letter
 
Join Date: Jan 2019
Posts: 9
Strogg is on a distinguished road
Default

I checked this tutorial and hmm...there are some points I don't understand.
Tried "Testing and Returning Text Strings with Logical Functions in Bookmarks", but
seems bookmark can't contain numbers, so I it could not be referred to bookmarks in IF construction.
Tried the below:
IF A1="330 ml" "33x26x20" "" IF A1="250 ml" "25x22x15" "" IF A1=0,0,"39x26x25" \* MERGEFORMAT \* MERGEFORMAT \* MERGEFORMAT \* MERGEFORMAT
But field return only "ml".
Sample attached.
What I'm doing wrong?
Attached Files
File Type: docx sample.docx (11.8 KB, 10 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a slide in PPT return to start page automatically? sawe90 PowerPoint 1 09-15-2018 12:56 PM
How make IF Formula return a numbers joined with a letter make single letter top to bottom of page-Large famreeks Word 3 04-27-2017 05:40 PM
Substring to return numbers funkyfido Excel 4 07-22-2016 10:03 AM
How make IF Formula return a numbers joined with a letter How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM
Words joined - how do i split? speaking Word 4 08-29-2011 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft