# How to return multiple values in multiple cells if argument is TRUE in IF functions?

1. ## How to return multiple values in multiple cells if argument is TRUE in IF functions?

I want my IF function to populate two cells with two values if argument for IF function is found TRUE. Is it possible?

IF(logical_test, [value_if_true], [value_if_false])

value_if_true = return multiple values in mutiple cells (for example put number 8 in cell A2 and number 10 in cell A3 if function is TRUE)

How would I do that? I tried putting IF(logical_test, (A2="8",A3="10"), [value_if_false]) but it is not possbile...

2. ## Re: How to return multiple values in multiple cells if argument is TRUE in IF functions?

hi WalkTalk, there's no way to do that in formulas. but couldnt you split them up in A2 & A3? in A2:
=IF(logical_test, 8, [value_if_false])

in A3:
=IF(logical_test, 10, [value_if_false])

might be possible in VBA though if you somehow cant use this

3. ## Re: How to return multiple values in multiple cells if argument is TRUE in IF functions?

---Duplicate Post----

4. ## Re: How to return multiple values in multiple cells if argument is TRUE in IF functions?

As benishiryo says - why not split the formula into both cells?

You can have both cells perform the IF function, and if you want the cells to be blank otherwise place a "" where false, I.E.:

=IF(logical_test, value_you_want,"")

5. ## Re: How to return multiple values in multiple cells if argument is TRUE in IF functions?

Originally Posted by benishiryo
hi WalkTalk, there's no way to do that in formulas. but couldnt you split them up in A2 & A3? in A2:
=IF(logical_test, 8, [value_if_false])

in A3:
=IF(logical_test, 10, [value_if_false])

might be possible in VBA though if you somehow cant use this
Hey benishiryo!

I already had two formulas in A2 and A3 like you suggested above so that is my main reason to open this thread and ask Excel gurus if there is any possibility to make only one formula.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.06126 seconds
• Memory Usage 8,939KB
• Queries Executed 14 (?)
Template Usage (32):
• (1)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (5)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (5)postbit_legacy
• (5)postbit_onlinestatus
• (5)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./includes/functions_notice.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php

Hooks Called (47):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit
• tag_fetchbit_complete
• forumrules