I am trying to enter the following if statment: =IF((E4>20000)&(F4>0.1999),"Explain:","")
I need to explain items greater than 20,000 AND 20% for a variance analyisis, but the fomula is not working - any idea what I am going wrong?
I first tried to make it a condirtital formatting, but that was even harder.
Bookmarks