if then else

[Andre0420]

Hello Folks, please help me with this formula. i have a very limited skill and i need your help. thank you

=IF(B9>=1,B9*50,"")+(IF(B10>=1,B10*20,""))

on the same column, i have 2 values; and on the very next cell under i must compute for the sum of the 2 cells above.

Andre

[#2]

@Andre0420 That formula will error when either B9 or B10 is less than 1. Avoid the the "" and replace them by zeroes.

=IF(B9>=1,B9*50,0)+(IF(B10>=1,B10*20,0))

Or, to avoid IF statements you can write it like this:

=(B9>=1)*B9*50+(B10>=1)*B10*20

[#3]

thank you, very much! i have used the if function but i certainly will explore the new knowledge you gave on the alternative. cheers!