Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2015, 08:39 PM
macropod's Avatar
macropod macropod is offline Return the value of a cell Windows 7 64bit Return the value of a cell 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


Try:
=IF(E5<>"","EE",IF(F5<>"","LL",IF(G5<>"","BP",IF(H 5<>"",504,IF(I5<>"","D","")))))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-09-2015, 06:18 AM
piper7971 piper7971 is offline Return the value of a cell Windows Vista Return the value of a cell Office 2007
Advanced Beginner
Return the value of a cell
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

Yes!!!! Thanks a lot!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find text within cell and return column and row title next to the name on a new sheet. tanyabowring@live.co.uk Excel Programming 2 03-26-2015 01:48 AM
How to return the first cell in a row? dapeamel Excel 0 02-26-2015 12:56 AM
Return the value of a cell Search for multiple texts in cell, return specific text mariur89 Excel 4 12-14-2014 01:33 AM
Would like to return a row rather than a cell using VLookup canajun Excel 7 12-10-2014 01:03 PM
Return the value of a cell Return cuurent time when another cell is updated zks Excel 6 01-22-2012 10:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 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