View original (French)

How to write a range in Excel

Solved

d -
Anonymous user - 1 Aug 2016 at 16:12

Hello,

how to represent this in excel:

10 <=cell_name <= 50

thank you

Configuration: Windows 7 / Firefox 3.6.13

Liens connexes:

3 réponses

Réponse 1 / 3

Price per hour = 1.000 if (30 <= age < 40)
Price per hour = 0.959 for other cases

Réponse 2 / 3

Ricky38 Posted messages 5776 Registration date Status Contributeur Last intervention 1 463

And if you could tell us what you really want to do?

Thank you
--
Every problem has a solution...you just have to be persistent.

Price per hour = 1.000 if (30 <= age < 40)
Price per hour = 0.959 for other cases

Ricky38 Posted messages 5776 Registration date Status Contributeur Last intervention 1 463

I don't understand your 30 <=age<40

should I understand that if aged between 30 and 40 years the price will be 1,000 otherwise the price will be 0.959?

yes

Ricky38 Posted messages 5776 Registration date Status Contributeur Last intervention 1 463

So if your age is in cell A1
In B1 you put: =IF(AND(A1>=30;A1<=40);1,000;0,959)

mordu

Hello
I would like to write in Excel the interval (10-11)=0.5 (11-12)=1 (12-13)=1.5 (13-14)=2 (14-15)=2.5 (15-n)=3

How to write a range in Excel

3 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french

Ccleaner starts at boot.