Hi
I am struggling with what i think is a condition formula, I have added a sheet as example and will try say what i need:
if E2 is (3or less(1,2,3) & C2 Matches A1 then = 5
some cells will be blank so may need =iferror
Cell A1 changes.
Thanks
Hi
I am struggling with what i think is a condition formula, I have added a sheet as example and will try say what i need:
if E2 is (3or less(1,2,3) & C2 Matches A1 then = 5
some cells will be blank so may need =iferror
Cell A1 changes.
Thanks
Maybe this...
=if(and(E2<=3,C2=A1),5,"")
I didnt look at your file yet
XCorrection...
=IF(AND(E2<=3,C2=$A$1),5,"")
Last edited by FDibbins; 03-23-2014 at 03:13 PM.
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
MATU70, Good afternoon.
Try to do:
G2 --> =IFERROR(IF(AND(C2=$A$1,E2<=3),5,""),"")
Please, tell us if it worked for you.
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
In G2 and copy down :
=IF(AND(E2<=3,C2=$A$1),5,"")
The IFERROR is unnecessary.
Hi
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Many Thanks to everyone
I used this one and works a treat:
=IF(AND(E2<=3,C2=$A$1),5,"")
Thanks Again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks