+ Reply to Thread
Results 1 to 6 of 6

If, And, isText? How best to construct my formulas to get desired result?

  1. #1
    Registered User
    Join Date
    02-13-2010
    Location
    los angeles, ca
    MS-Off Ver
    Excel 2010
    Posts
    9

    If, And, isText? How best to construct my formulas to get desired result?

    Thank god for forums like these!

    I'm not completely new to Excel but I just can't seem to wrap my head around how best to work with formulas to achieve the desired result. I've spent a good deal of my day trying to figure it out /wince.

    I have attached files for better understanding.


    Capture.JPGCapture2.JPG


    I have a sheet that breaks down weekly jobs by day, the amount collected and also some drop down selection boxes to pick a contractor and enter how much they were paid for their services.

    My goal is to have a payout sheet that will take data as it is entered into the weekly tracker and organize it so it so the output automatically shows how much each individual contractor is paid per week.

    I tried some: =IF(AND() but I think i'm doing it wrong. I want the payout sheet to do this in plain english:

    Go to cell B3, If there is no text or number, display nothing. IF there IS a data/number/text then check the data range of names (a5:a11) if the name is "Victor", display the data on the same row in column B (cell b5). If it could auto populate the name of the customer that would be great too but i think that will need to be just a Istext statement on its own.

    I have no clue if this is the optimal way to get the desired result. I respect everyone who helps as it's above me lol!

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: If, And, isText? How best to construct my formulas to get desired result?

    Please attach a sample workbook..
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    02-13-2010
    Location
    los angeles, ca
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: If, And, isText? How best to construct my formulas to get desired result?

    Here is a sample attachment
    Attached Files Attached Files

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: If, And, isText? How best to construct my formulas to get desired result?

    I am unable to open that workbook.. Excel shuts dwn when I open the workbook..

  5. #5
    Registered User
    Join Date
    02-13-2010
    Location
    los angeles, ca
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: If, And, isText? How best to construct my formulas to get desired result?

    Really? It's office 2010 workbook. could that be the reason?Attachment 26121507.13 Weekly Tracker2.xls

    here is a older 2003 version.

  6. #6
    Registered User
    Join Date
    02-13-2010
    Location
    los angeles, ca
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: If, And, isText? How best to construct my formulas to get desired result?

    I uploaded a new file. The payroll tab has just plain data entered as an example of what I would like to populate automatically from the other. If anyone knows a better way to achieve this, please do tell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nesting IF, AND & ISTEXT Formulas
    By hogg_russell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2013, 11:16 AM
  2. Replies: 3
    Last Post: 09-12-2012, 04:58 AM
  3. IF(ISTEXT to ignore formulas
    By JO505 in forum Excel General
    Replies: 2
    Last Post: 10-19-2011, 04:31 PM
  4. Mixed Formulas using '&' with desired result not showed
    By matthew. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2009, 10:42 PM
  5. IF and SUM not returning desired result
    By SRussell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2008, 03:59 PM

Tags for this Thread

Bookmarks

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.99684 seconds
  • Memory Usage 9,010KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (6)postbit_legacy
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
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
  • ./showthread.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_facebook.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
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • 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
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1