Thread: [Solved] How to change the formula
View Single Post
 
Old 07-12-2019, 03:04 AM
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
Code:
 IIf(AND(D7 = "", F7=""), "", G6+D7-SUM(F7))

SUM(F7) is used instead of F7 because of "-" in column F.
Reply With Quote