markswan111
New Member
- Joined
- Sep 16, 2016
- Messages
- 33
[h=2]hello guys, I am trying to use to nested if function for two logical tests, but it won't work on excel 2007 no matter what I try, it says invalid formula...[/h]
=IF(E2="mark",m7*.01, IF(E2="james",m7*.01 , "nothing "))
any one can help?
=IF(E2="mark",m7*.01, IF(E2="james",m7*.01 , "nothing "))
any one can help?