I need help with creating a formula with two logical tests. I got the first one but can't figure out how to include the second logical test.
![](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FKpn8I.jpg&hash=c9d02a0ba41aba6f5270f09ecae29eed)
I also need to add to this formula that if M40="6%" than times 106%, if blank N40. I tried adding a second IF, using AND function but not getting what I need.
Thank You for your help!
![](/board/proxy.php?image=https%3A%2F%2Fi.stack.imgur.com%2FKpn8I.jpg&hash=c9d02a0ba41aba6f5270f09ecae29eed)
I also need to add to this formula that if M40="6%" than times 106%, if blank N40. I tried adding a second IF, using AND function but not getting what I need.
Thank You for your help!