Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2019, 03:18 AM
macropod's Avatar
macropod macropod is offline How make IF Formula return a numbers joined with a letter Windows 7 64bit How make IF Formula return a numbers joined with a letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word did not insert the \* MERGEFORMAT switches as a result of applying anything in the tutorial. What's the point of the SKIPIF field in cell B1?



Done properly, your IF field code would look like:
{IF{=A1}= 330 "33x26x20" {IF{=A1}= 250 "25x22x15" "39x26x25"}}
You could even use a field coded as:
{=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



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 08:06 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