How to get one value from 2 different cells

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

09-29-2019, 11:13 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 AM.