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 ...
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!