I know I am asking something so simple, but I am new to excel, already easy to use but having problem to make formula, equal to value of a4:
=A4 if A1 and A2 are blanks and A3 is between 30-50
or
=A4 if A1=10, A2=20, A3 between 30-50
Thank you so much
Hi & welcome to the board.
How aboutFormula:
=IF(MEDIAN(A3,30,50)=A3,IF(OR(AND(A1="",A2=""),AND(A1=10,A2=20)),A4,""),"")
Very nice of you ...but sadly I made a mistake , I meant equal cell A3, sorry my bad.
=A3 if A1=10, A2=20, A3 between 30-50
Thank you so much again
Just change the A4 to A3. The rest of the formula is the same
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you so much for a very quick and easy solution.I really appreciate it.
Removed by me
Glad 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