HELP with IF based on ranges

Posted by Member JensenBreck on 11/21/17 12:13 AM #1
Posts: 72

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?


Please help....


I didn't find the right solution from the Internet.
References
https://productforums.google.com/forum/ … forum/docs

Branding Motion Graphics Examples

You must log in or register to reply.
1 users posted in this thread: JensenBreck

© 2018 DiabloHub | Privacy Policy | Terms of Use | Contact