Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Hello Experts,

Can someone please assist me in writing a formula that will do the following:

In cell G3 if cell D3 is > 4 but less than 20 then insert the following character v

In cell H3 if cell D3 is >21 but less than 50 then insert the following character v

In cell I3 if cell D3 is > 51 insert the following character v

In cell J3 if cell D3 is greater than 1 but less than 4 then insert the following character v

Your help will greatly appreciated.

Regards

Carlton

AMALGAMATION.xlsx

Can someone please assist me in writing a formula that will do the following:

In cell G3 if cell D3 is > 4 but less than 20 then insert the following character v

In cell H3 if cell D3 is >21 but less than 50 then insert the following character v

In cell I3 if cell D3 is > 51 insert the following character v

In cell J3 if cell D3 is greater than 1 but less than 4 then insert the following character v

Your help will greatly appreciated.

Regards

Carlton

AMALGAMATION.xlsx

...Terry

>> In cell G3 if cell D3 is > 4 but less than 20 then insert the following character v

=IF(AND(D3>4,D3<20),"v",""

>>In cell H3 if cell D3 is >21 but less than 50 then insert the following character v

=IF(AND(D3>21,D3<50),"v","

>>In cell I3 if cell D3 is > 51 insert the following character v

=IF(D3>51,"v","")

>>In cell J3 if cell D3 is greater than 1 but less than 4 then insert the following character v

=IF(AND(D3>1,D3<4),"v","")

cheers, teylyn

Here is the update to include ">="

AMALGAMATION.xlsx

AMALGAMATION.xlsx

In H3 put =IF(D3>=21,IF(D3<=50,"V","

In I3 put =IF(D3>=51,"V","")

In J3 put =IF(D3>=1,IF(D3<=4,"V","")

The attached has got the formulas included (you'll just need to fill down).

amalgamation.xlsx

Is it possible to make excel recognise a character as a number? For example, the values in the formulas you suggested will be 'V'. I would Excel to recognise 'V' as the value number 1, so that I can total the 'V's.

I hope that makes sense

=COUNTIF(G:G,"v")

Or replace the "v" with a 1, then you can sum the results. So, instead of...

=IF(AND(D3>4,D3<20),"v",""

... use

=IF(AND(D3>4,D3<20),1,0)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

...Terry

AMALGAMATION.xlsx