LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 208
Default Adding text to an IF statement effeciently

I have the following code in a cell on Sheet A:

=IF(E41H41,"Rock on, Man! You are EXCEEDING your Stretch goal for the
month!",IF(E41=H41,"Nice work! You are meeting your stretch goal for the
month!",IF(E41=G41,"Great work. You are meeting your Target
goal.",IF(E41=F41,"You are meeting Threshold. Which is the bare
minimum.",IF(E41<F41,"Um... so yeah... you might want to do some work,
Dude.")))))

What I would like to do is assign each quote to a variable on Sheet B like
such:

exceed = "Rock on, Man! You are EXCEEDING your Stretch goal for the month!"
stretch = "Nice work! You are meeting your stretch goal for the month!"
target = "Great work. You are meeting your Target goal."
threshold = "You are meeting Threshold. Which is the bare minimum."
slack = "Um... so yeah... you might want to do some work, Dude."

And I would like to replace the code above with something like this:

=IF(E41H41,exceed,IF(E41=H41,stretch,IF(E41=G41 ,target,IF(E41=F41,threshold,IF(E41<F41,slack)))) )

What is the correct syntax to make this work?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a statement to several documents Newbee Excel Worksheet Functions 2 March 17th 08 04:41 PM
How to protect and unprotect multiple worksheets effeciently Sumknight Excel Discussion (Misc queries) 4 February 23rd 07 08:10 PM
Adding A Not(IsBlank) To IF Statement(help) getmhawks Excel Worksheet Functions 2 June 12th 06 10:43 PM
How do I effeciently share text from two different sheets? kristina Excel Worksheet Functions 2 December 6th 05 11:24 PM
adding if statement results Robb27 Excel Worksheet Functions 3 November 20th 04 05:27 AM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"