#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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,"")) Code:
=IF(AND(F6="Y",L6="N"),"",IF(AND(F6="N",L6="Y"),"",E6-K6)) |
#3
|
|||
|
|||
owner
Hi,
Perfectly worked thanks for your prompt response sir. Sincerely Iraj |
|
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 |