Using if/then functions in Excel

[Gary]

I'm new to functions... How do I write the function "If cell D3 has any
character in it, then cell D4 = 1. If it has no characters, cell D4 = 0"

How about "If cell D3 has the word 'truck' in it, then cell D4 = 1"

Lastly, if I have a column of words such as car, truck, car, bus, bus, can
I somehow total the number of times "car" and "truck" appeared in the column?

Thanks,
Gary

 

[Murthy]

I'm new to functions... How do I write the function "If cell D3 has any
character in it, then cell D4 = 1. If it has no characters, cell D4 = 0"

Put this formula in D4

How about "If cell D3 has the word 'truck' in it, then cell D4 = 1"

Put this in D4
=if(D3="truck",1)

Lastly, if I have a column of words such as car, truck, car, bus, bus, can
I somehow total the number of times "car" and "truck" appeared in the column?

Look for COUNTIF in help. You should be able to do it..

- Murthy

 

[Stefi]

I'm new to functions... How do I write the function "If cell D3 has any
character in it, then cell D4 = 1. If it has no characters, cell D4 = 0"

Write in D4:
=IF(ISBLANK(D3),0,1)

How about "If cell D3 has the word 'truck' in it, then cell D4 = 1"

Write in D4:
=IF(D3="truck",1,"otherwise")

Lastly, if I have a column of words such as car, truck, car, bus, bus, can
I somehow total the number of times "car" and "truck" appeared in the column?

Write anywhere:
=COUNTIF(D,"car")

Regards,
Stefi

 

[Gary]

Thanks!

Put this formula in D4


Put this in D4
=if(D3="truck",1)


Look for COUNTIF in help. You should be able to do it..

- Murthy

 

[Gary]

Thanks!

Write in D4:
=IF(ISBLANK(D3),0,1)

Write in D4:
=IF(D3="truck",1,"otherwise")



Write anywhere:
=COUNTIF(D,"car")

Regards,
Stefi

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Gary†ezt írta: