excel programming

[Xaccers]

Can someone tell me how to put the following into excel so that it knows what I'm talking about?

IF A1 = 1 then print contents of B1 in C1

[Richard M]

I think (from memory) you just click on the f icon to create a function.
It's next to the thing that looks like an address bar.

[Xaccers]

But what would the syntax of the function be?

[Richard M]

Originally Posted by Xaccers

But what would the syntax of the function be?

Screenshot below:

[Xaccers]

Thanks Richard

Do you know how I can get it to hide rows where the value isn't 1?

Basically I've got several clients' backup reviews allocated to several colleagues.

I want to produce on a seperate sheet within the workbook a list of allocated clients for each collegue.
Allocation is done by putting a 1 in the collumn/row of colleague/client

So I'm getting the list when I try what you said, but it's showing all the falses in between client names.

[Richard M]

Not sure, but the help file says this:

Formula
=IF(A2<=100,"Within budget","Over budget")
Description (Result)
If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)

So, you'd replace the "Within budget" part of that with the Hide commands, whatever they are.
I know you can access Hide from Format>Row>Hide but I'm a bit of a n00b when it comes to Office.

[Tricky]

Originally Posted by Xaccers

Thanks Richard

Do you know how I can get it to hide rows where the value isn't 1?

Basically I've got several clients' backup reviews allocated to several colleagues.

I want to produce on a seperate sheet within the workbook a list of allocated clients for each collegue.
Allocation is done by putting a 1 in the collumn/row of colleague/client

So I'm getting the list when I try what you said, but it's showing all the falses in between client names.

You could only do this via a Macro unless someone wants to correct me!

[Xaccers]

Originally Posted by Tricky

You could only do this via a Macro unless someone wants to correct me!

You are correct, I managed to find one on the web