Forum Discussion
if then else
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 Replies
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
- thank you, very much! i have used the if function but i certainly will explore the new knowledge you gave on the alternative. cheers!
