Defined output based on Input given

Hi

i have table with 4 coloum

first 3 contain input and last one contain output

my query.

in the table if all 3 input Coloum have any value it give output in 4 coloum 150

in the table if all 2 input Coloum have any value and one is blank, it give output in 4 coloum 100

in the table if all 1 input Coloum have any value and 2 are blank, it give output in 4 coloum 50

in the table if all 3 input Coloum are blank, it give output in 4 coloum 0

input 1	input 2	input 3	Output
10	20	30	150
10	20		100
10			50
			0

i would love any Function/ formula

I am not sure if this what you want, but you can try it in column E

Please Login or Register  to view this content.

Naveed,
Good!
I did a single column comparison, which is probably wrong. What do you the return values in "" as if they were string?

Duplicate post

http://www.excelforum.com/excel-prog...put-given.html