Thread: How to get one value from 2 different cells
View Single Post
 
Old 09-29-2019, 11:13 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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