Hi All, could you assist me.
1)
BK190=$397,000.00
BK193=$404,184.83
BK200=$7,184.83
BK202=$7,184.83
=IF(OR(BK190>=BK193,BK200>=BK202), "SUFFICIENT","INSUFFICIENT")
The results shows "INSUFFICIENT". It should be SUFFICIENT as bk200=bk202
I have another case below which applies the same forumula and show correctly.
2)
BD190= $49,000.00
BD193= $113,928.57
BD200= $64,928.57
BD202= $64,928.57
=IF(OR(BD190>=BD193,BD200>=BD202), "SUFFICIENT","INSUFFICIENT")
The results shows "SUFFICIENT" which is correct.
Bookmarks