Thread: IF result blank
View Single Post
  #1   Report Post  
Micayla Bergen
 
Posts: n/a
Default IF result blank

my formula
=IF(OR(IF(W3="ACQUIRE",SUM(H3:I38)*(W4+V5))),IF(W3 ="REDUCE",SUM(H3:I38)*(W4-V5)),"")
should be blank if false but it returns FALSE. where have i gone wrong?
thank you