Evening All,
i have to cells running =IF (D29 & D31) , D29 is for if the value of N14 is equal to or less than 35999.99 (if it is more to display 0) & D31is for if the value of N14 is equal to or greater than 36000 (if it is less to display 0).
the Formula in D29 is =IF(N14<="35999.99",SUM(B29/100*20)+(B29/100*12),"0")
the Formula in D31 is =IF(N14>="36000",SUM(B29/100*40)+(B29/100*12),"0")
any help in this matter would be greatley appriciated.
Cheers
Bookmarks