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: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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