Change cell value based on multiple other cells (=IF?)

[farmertml]

Hi All,

I have a quick question and will describe best what I want to achieve.

I have a spreadsheet with 4 cells in row 1 (A1,C1,F1,H1)
I want the value of A1 to change based on the content in cells C1 F1 & H1

If cells C1 F1 & H1 are all blank then A1 should = 1
If cell C1 has something in (and the other 2 are blank) then A1 should = 2
If cell F1 has something in (and the other 2 are blank) then A1 should = 3
If cell H1 has something in (and the other 2 are blank) then A1 should = 4

If Cells C1 and F1 have something in then A1 should = 3 (taken from the fact there is something in F1)
If Cells F1 and H1 have something in then A1 should = 4 (taken from the fact there is something in H1)
If Cells C1 F1 & H1 have something in then A1 should = 4 (taken from the fact there is something in H1)

I'm assuming this could be done using an =IF() formula but I can't work out what it should be.

I hope that's clear but if you need any other info then please let me know.

Thanks very much in advance for any light you can shed on this for me.

 

[Andrew Poulsom]

Try:

=IF(LEN(H1),4,IF(LEN(F1),3,IF(LEN(C1),2,1)))

 

[farmertml]

You sir are a genius, thank you very much.

Could you explain how the LEN works in this case, it's quite interesting.

Thanks again.
Paul

 

[Andrew Poulsom]

The LEN function returns the number of characters in its argument. Zero is returned if the cell is empty.