 • 579K Members
• 4,520 Online
• 701K Conversations
SOLVED

Highlighted

# add criteria to the following formula

I would like to add criteria to the following formula that says if cell BB30 has any data then true, if not cell remains blank

=IF(AND( IF(\$D\$20>0,\$AB30<\$AC30,1), IF(\$F\$20>0,\$AD30<\$AE30,1), IF(\$H\$20>0,\$AF30<\$AG30,1), \$AH30<\$AI30, \$AJ30<\$AK30, \$AL30<\$AM30, \$AN30<\$AO30, \$AP30<\$AQ30, ((\$D\$20>0)+(\$F\$20>0)+(\$H\$20>0)) ), (\$Q30/\$P30),"")

Solution

# Re: add criteria to the following formula

Hi Greg,

You formula

`=IF( AND(...), (\$Q30/\$P30), "")`

you could modify as

`=IF( AND(...)*(LEN(BB30)>0), (\$Q30/\$P30), "")`

If any data it changes nothing, if not entire expression is FALSE and formula returns empty string

Related Conversations
I want users to add New lines items in response
osman_124 in Microsoft Forms on
1 Replies
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies