I think I need a nested If function and maybe an "ISBLANK" function

[GWells]

Hi guys,

So I have three columns where only one column contains a number and the other 2 columns are blank. I need to multiply each column by a different factor depending on which column it lands in.

So if the number falls in column A, then multiply by 100, if the number falls in column B then multiply by 100 and column C by 10. Answer to go into D1

Thanks for your help.

[etaf]

can you have columns that are not blank
so
A1 = blank B1=number c1=number
and what to do then

=IF(ISNUMBER(A1), A1*100, IF(ISNUMBER(B1), B1*100, IF(ISNUMBER(C1), C1*10, "what to do if all blank"))

BUT this will not test to see if you have more than one number
otherwise

IF ( AND(ISNUMBER(A1), B1="", C1="") , A1*100 ,
IF ( AND(ISNUMBER(B1), A1="", C1="") , B1*100 ,
IF ( AND(ISNUMBER(C1), A1="", B1="") , C1*10 , " what to do if more numbers" )))

=IF(AND(ISNUMBER(A1),B1="",C1=""),A1*100,IF(AND(ISNUMBER(B1),A1="",C1=""),B1*100,IF(AND(ISNUMBER(C1),A1="",B1=""),C1*10," what to do if more numbers,or all blanks")))

or
=IF(AND(ISNUMBER(A1),ISBLANK(B1),ISBLANK(C1)),A1*100,IF(AND(ISNUMBER(B1),ISBLANK(A1),ISBLANK(C1)),B1*100,IF(AND(ISNUMBER(C1),ISBLANK(A1),ISBLANK(B1)),C1*10," what to do if more numbers or all blank")))

NOTE - if you are using a formula to fill the blanks ie ""
then is blank will not work -as ISBLANK looks for a NULL and not an empty string
"" creates an empty string and ISBLANK will return a true , even though the cell is empty

[GWells]

Hi etaf!

Thanks for your response! That worked perfectly! Have a great day!

[etaf]

your welcome
I believe you can mark the thread solved

to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.