ok.. thanks a lot guys... but til now im not getting the correct one.. i have another option:
in 1ST CELL say C11 i have ds formula =IF(AND(C$4="LOCAL",C$6="G.I. SHEET"),(C$13+80),0)
now, on 2ND CELL, IF ON 1ST CELL THE RESULT IS 0, THEN...
Can u send me a test mail pls.. on my yahoo... am still not getting it.. maybe it will help if il send my worksheet so u can take a look at it.. karena_narvaez@yahoo.com.
Thank you very much.
THE VALUE SHOULD GIVE ME AY13+80, OTHERWISE IT SHOULD GIVE ME AY+110 OR ZERO..
2ND RESULT HAS 2 OPTION EITHER IT GIVES ME AY+110 OR IT WILL GIVE ME ZERO.
=IF(AND(AY$6<>"G.I. SHEET",(OR(AY$4="IMPORT",AY$4="LOCAL"))),(AY$13+80),(OR(AY$13+110,0)))
this formula should give me a zero value but its giving me "TRUE"
CAN SOMEBODY HELP ME PLS.