IF result blank

M

Micayla Bergen

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
 
C

CLR

Try this..........

=IF(W3="ACQUIRE",SUM(H3:I38)*(W4+V5),IF(W3="REDUCE",SUM(H3:I38)*(W4-V5),""))

Vaya con Dios,
Chuck, CABGx3
 
Top