Cable Forum - excel programming

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - excel programming (https://www.cableforum.uk/board/showthread.php?t=7615)

Xaccers

12-02-2004 16:36

excel programming

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

12-02-2004 16:49

Re: excel programming

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. :erm:

Xaccers

12-02-2004 16:50

Re: excel programming

But what would the syntax of the function be?

Richard M

12-02-2004 16:53

Re: excel programming

1 Attachment(s)

Quote:

Originally Posted by Xaccers

But what would the syntax of the function be?

Screenshot below:

Xaccers

12-02-2004 17:01

Re: excel programming

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

12-02-2004 17:11

Re: excel programming

Not sure, but the help file says this:

Quote:

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

12-02-2004 18:47

Re: excel programming

Quote:

Originally Posted by Xaccers

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

Xaccers

12-02-2004 18:52

Re: excel programming

Quote:

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 :)

All times are GMT. The time now is 20:06.