ExcelBanter - If a number is between 1 & 4 then do X else do XY

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If a number is between 1 & 4 then do X else do XY (https://www.excelbanter.com/excel-discussion-misc-queries/189027-if-number-between-1-4-then-do-x-else-do-xy.html)

Maggie

If a number is between 1 & 4 then do X else do XY

I want to find out how to do an If formula which gives a result if the
condition is between two numbers?

Teethless mama

If a number is between 1 & 4 then do X else do XY

=IF(AND(A1=1,A1<=4),"X","XY")

"Maggie" wrote:

I want to find out how to do an If formula which gives a result if the
condition is between two numbers?

muddan madhu

If a number is between 1 & 4 then do X else do XY

can it be ?

=IF((A10)*(A1<5),"X","XY")

On May 28, 7:31*am, Teethless mama
wrote:
=IF(AND(A1=1,A1<=4),"X","XY")

"Maggie" wrote:
I want to find out how to do an If formula which gives a result if the
condition is between two numbers?- Hide quoted text -

- Show quoted text -

All times are GMT +1. The time now is 05:17 AM.