How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I AM TRYING TO CREATE A FORMULA IN EXCEL BUT NOT HAVING MUCH

This answer was rated:

I AM TRYING TO CREATE A FORMULA IN EXCEL BUT NOT HAVING MUCH LUCK
IF CELL A0 BUT LESS THAN 31 THEN VALUE OF CELL D TO BE COPIED INTO CELL G

THANKS, XXXXX XXXXX CAN HELP ME
LEANNE
Hello Leanne,


In cell G2 copy or type the following formula

=IF(AND(A2=0,A2<31),D2,"")

which translates to if A2 is 0 and A2 is less than 31 then show the value of D2 in cell G2


Hope this helps. If that is not exactly what you're trying to do please get back to me so I can modify the formula




Otherwise thank you for remembering to rate the answer if you found it helpful


I will be posting the file on this page. So make sure to come back to this page to download the file
John D and 4 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.

thanks John, it wasnt exact but close enough that I could figure it out from there.


loeanne


 

Great. Let me know in case you need further help, and thanks for the rating :)

Related Microsoft Office Questions