I need some basic help on this i m stuck please if anyone can help ?
sheet attached
I need some basic help on this i m stuck please if anyone can help ?
sheet attached
Use this in G8:
=IF(AND(OR(E8="UK",E8="Germany"),F8>100000),"Bonus","No Bonus")
then copy down as needed.
Hope this helps.
Pete
=IF(AND(OR(E8="UK",E8="Germany"),F8>100000),"Bonus","")
Try this formulaPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks