New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Seeking Help to resolve, Reference from two specific cells of specific text then make addition in another cell.

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Seeking Help to resolve, Reference from two specific cells of specific text then make addition in another cell.

Postby Umair » Thu Jan 21, 2016 1:51 am

I am preparing a worksheet where I want to take a,
Reference of specific text from Cell A1, if cell A1 contain a text "yes"
then look on Cell A2,
if A2 has text "February" then plus 1 in the value of Cell A3 and show in Cell A4.
if Cell A1 is "No" but Cell A2 is "February" then keep the Cell A4 blank
but
if Cell A2 contain any other value except "February" formula should plus 1 always in Cell A3 value and show in Cell A4.

I am not expert in excel, consider me a binger and advise please.
An expert guidance can solve my problem as well as can be help me to learn.
your guidance will be highly appreciated...
  • 0

Umair
Rookie
 
Posts: 1
Joined: Jan 21, 2016
Reputation: 0
Excel Version: 2013

Re: Seeking Help to resolve, Reference from two specific cells of specific text then make addition in another cell.

Postby Beamer » Fri Jan 22, 2016 5:21 am

That's a little confusing, a few conditions missing.

Conditions for A3:
IF A1="Yes" and A2="February" then A3=+1
IF A1="No" and A2="February" then A3= ????
IF A1= anything???? and A2<>"February" then A3=+1

Conditions for A4:
IF A1="Yes" and A2="February" then show in A4
IF A1= anything???? and A2<>"February" then show in A4
Otherwise leave blank.

2 more points.
Where you say "plus 1 in Cell A3"....Does that mean show a 1 in A3? If it means add 1 to the existing number in A3 then I believe you'll need a VBA macro to do it.
Where you say "show in A4" what do you want to show in A4 exactly?

Looking forward to helping you :)
  • 0

Beamer
Excel Junkie
 
Posts: 217
Joined: Oct 3, 2014
Location: New South Wales, Australia
Reputation: 31
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 138 guests