"IF" Function

Hey guys,

I'm trying to create a spreadsheet which consolidates a lot of other data, reducing duplicate inputs.

basically the situation is this:
If a cell B1 has a value (>1), cell C1 has a name, the same name as A1. I'm using this formula:
=IF(B1>=1,"Apple","")
The trouble is I need the word "Apple" to change when the input in A1 changes. So I need a formula similar to
=IF(B1>=1,"A1","")
But obviously the above doesn't work!

Any help would be much appreciated, I've spent at lot of time playing around with this but to no avail!

Hi not entirely clear what you want but if it is that

If B1 is greater than or equal to 1 and C1 = A1, your_result, else leave blank

This will do

=IF(and(B1>=1,C1=A1),your_result,"")

Ed

Hey EdMac, thaknks for the reply.

What I'm trying to achieve is:

If B1 is greater than or equal to 1, C1 = A1, Otherwise leave blank.

Its a similar sentance to yours but slightly different, any ideas?

Hi Beale

In C1

If(B1>=1,A1,"")

Logic: If B1>=1, use value in A1, else leave blank

You were nearly there - cell references never have "" marks around them

Ed

Ah! Works great, thanks for your help on this!

No problem.

Thanks for the feedback

Ed