I have tried this formula and the result is ' to many arguments' Can someone simplify it so it works ?
Both arguments work separately ie.=IF(INPUT!D52="Lav","",INPUT!E52) =IF (INPUT!D52="Hunt","",INPUT!E52)
=IF(INPUT!D52="Lav","",INPUT!E52,IF(INPUT!D52="Hunt","",INPUT!E52))
Any assistance word be greatfully appreciated.
Untested...
=IF(or(INPUT!D52="Lav",INPUT!D52="Hunt"),"",INPUT!E52)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe like this ...
=IF(OR(INPUT!D52={"Lav","Hunt"}),"",INPUT!E52)
Try
=IF(OR(Input!D52={"Lav","Hunt"}),"",Input!E52)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks