Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2015, 06:18 PM
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 Return the value of a cell

HI!
Is it possible to have a formula in excel that checks if E5, F5,G5,H5,I5 are empty and if it is not then return a value for the cell that is not empty?



I have a worksheet where the person needs to mark one of those cells and I need a formula that if the marked one is E5 then return the letters EE if the marked one is F5 return LL, if the marked one is G5 return BP, if the marked one is H5 return 504 or if the marked one is I5 return D.

Can this be possible? if so how?

I HAVE TRIED THIS:
=IF(AND(SUBGRUPOS!E5="EE","EE","",SUBGRUPOS!F5="LL ","LL","",SUBGRUPOS!G5="BP","BP","",SUBGRUPOS!H5=" 504","504","",SUBGRUPOS!I5="D","D",),"")

BUT IT RETURNS A #VALUE ERROR

Last edited by piper7971; 06-09-2015 at 06:22 AM. Reason: SOLVED
Reply With Quote
  #2  
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: 21,065
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
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
  #3  
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
  #4  
Old 06-09-2015, 06:22 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

Hoe do i post it as solved?
Reply With Quote
  #5  
Old 06-09-2015, 03:00 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: 21,065
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by piper7971 View Post
Hoe do i post it as solved?
Via the 'Thread Tools'. Done.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 - Senior Forums

All times are GMT -7. The time now is 04:23 PM.


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