W
woozlemonk
I want to create an if statement in excel that fits into the following
=if(H10="",sum(H11:*****Here*****),IF(G11="","",G11*IF(ISNA(VLOOKUP(F11,A:H,8,FALSE))=TRUE,VLOOKUP(F11,PRICING!A:C,3,FALSE),VLOOKUP(F11,A:H,8,FALSE))))
where here is the next cell with a value of ""
which would effectively do the following and be a completely coded column
without any need for change
SUM
number
number
number
number
SUM
Number
Number
Number
SUM
Number
Number
Number
Number
Number
Number
=if(H10="",sum(H11:*****Here*****),IF(G11="","",G11*IF(ISNA(VLOOKUP(F11,A:H,8,FALSE))=TRUE,VLOOKUP(F11,PRICING!A:C,3,FALSE),VLOOKUP(F11,A:H,8,FALSE))))
where here is the next cell with a value of ""
which would effectively do the following and be a completely coded column
without any need for change
SUM
number
number
number
number
SUM
Number
Number
Number
SUM
Number
Number
Number
Number
Number
Number