Posted by Member JensenBreck on 11/21/17 12:13 AM
Hi im having an issue with setting up an IF for a range.
Say I have data on cells A1:E1, some may show up as text, other as numbers and some blank, For example
A1 B1 C1 D1 E1
X 3 L
I want for F1 to be an IF based on the range A1:E1 where If A1:E1 is blank this gives "120" but when there is a value or text somewhere on A1:E1, to give me "0".
Any idea on how i can get this done?
I didn't find the right solution from the Internet.
https://productforums.google.com/forum/ … forum/docs
Branding Motion Graphics Examples