Microsoft Office Forums How to get one value from 2 different cells

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-28-2019, 03:37 PM
Iraj Iraj is offline How to get one value from 2 different cells Windows 7 64bit How to get one value from 2 different cells Office 2007
Novice
How to get one value from 2 different cells
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default How to get one value from 2 different cells

Please help;



Please give a formula that can choose from 2 different cells just one value.


1- I want to have a formula in P2, P3, and so on, when F2 cell is Y the amount from cell E2 shows in P2 cell. But when L2 is Y, then P2 Turns Blank and differences ofE2 & K2 cells shows in O2.

2- Another condition for P2, if now F2 is N, but L2 is Y the same P2 shows K2 Value with negative sign example here(-250), and later when F2 cell is turns to Y, P2 becomes blank again and differences of E2 & K2 cells shows in O2.

Please any idea, check the attached sheet and instruct.
Thanks.
Iraj.
Attached Files
File Type: xlsx GS Customer sheet.xlsx (210.1 KB, 3 views)
Reply With Quote
  #2  
Old 09-29-2019, 11:13 PM
ArviLaanemets ArviLaanemets is offline How to get one value from 2 different cells Windows 8 How to get one value from 2 different cells Office 2016
Expert
 
Join Date: May 2017
Posts: 486
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about
Default

Your range references seem off somehow! I assume datarange starts from row 6:
for P6
Code:
=IF(AND(F6="Y",L6="N"),E6,IF(AND(F6="N",L6="Y"),-1*K6,""))
for O6
Code:
=IF(AND(F6="Y",L6="N"),"",IF(AND(F6="N",L6="Y"),"",E6-K6))
Reply With Quote
  #3  
Old 09-30-2019, 04:05 PM
Iraj Iraj is offline How to get one value from 2 different cells Windows 7 64bit How to get one value from 2 different cells Office 2007
Novice
How to get one value from 2 different cells
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default owner

Hi,

Perfectly worked thanks for your prompt response sir.

Sincerely Iraj
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Borders on merged cells also appearing on unwanted adjacent cells MrsC Word Tables 2 08-19-2019 09:14 AM
Conditional formating all cells in an array based on adjacent cells deejay Excel 6 12-20-2016 12:00 PM
How to get one value from 2 different cells Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM


All times are GMT -7. The time now is 06:14 PM.


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