Tough Formula Question :-?

miroj1

Board Regular
Joined
May 6, 2002
Messages
52
HI, LOVE THE WEBSITE BUT I DO HAVE A QUESTION THAT RELATES TO THE FOLLOWING FORMULA:
=IF(A1<=12000,"Poor",IF(A1<=15000,"OK","Good"))

THIS WAS A NESTED FORMULA THAT YOU PUT TOGETHER FOR A COLLEGE STUDENT. LOOKING AT THE FORMULA TEXT IN PARENTHESIS ARE LISTED IF A CERTAIN NUMBER COMES UP.
MY QUESTION IS HOW CAN YOU DISPLAY A CONTENT OF A CELL RATHER THAN THE WORD “POOR” OR ‘GOOD’?
HERE IS THE FORMULA I AM TRYING TO CORRECT:
IF A1=B1,D5 …

IN OTHER WORDS IF THE VALUE (OR TEXT) IN CELL A1=THE VALUE(OR TEXT) IN CELL B1, I THEN WANT TO PRINT OUT THE VALUE IN CELL D5.

THANKS FOR THE TIME AND EFFORT!
ROGER
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
In other words if the value (or text) in cell A1=the value(or text) in cell B1, I then want to print out the value in cell D5.

=IF(A1=B1,D5,"?")
 
Upvote 0
Boy that was quick, but let me take it one step further... what if I wanted to show the contents of 2 or more cells, for example d5 to d10 ? What do I type then?
This message was edited by miroj1 on 2002-05-07 23:35
 
Upvote 0
On 2002-05-07 23:23, miroj1 wrote:
Boy that was quick, but let me take it one step further... what if I wanted to show the contents of 2 or more cells, for example d5 to d10 ? What do I type then?
This message was edited by miroj1 on 2002-05-07 23:35

Depends on what you mean by: show the contents of 2 or more cells, for example d5 to d10? Do you want them sum, average, count...?
 
Upvote 0
Well I thought it worked well until I tried the formula and instead of (e.g.) 45 65 32 54 62 17, I end up with 456532546217... how do I get those spaces in the result while using the formula:
=IF(D23=F23,CONCATENATE(G23, G24, G25, G26, G27, G28, G29, G30),"?")

Thanks again!
 
Upvote 0
On 2002-05-08 14:58, miroj1 wrote:
Well I thought it worked well until I tried the formula and instead of (e.g.) 45 65 32 54 62 17, I end up with 456532546217... how do I get those spaces in the result while using the formula:
=IF(D23=F23,CONCATENATE(G23, G24, G25, G26, G27, G28, G29, G30),"?")

Thanks again!

The & below does the same as the concatenate but its much easier to use.

=IF(D23=F23,G23&" "&G24&" "&" "&G25&" "&G26&" "&G27&" "&G28&" "&G29&" "&G30,"?")
 
Upvote 0
On 2002-05-08 15:04, miroj1 wrote:
I still need an answer on the previous reply? Thanks for all your help. Roger.

OK, since you want to concatenate the contents of a range of consecutive cells, you could use MCONCAT from the add-in Morefunc, downloadable from:

http://longre.free.fr/english/index.html

After adding in Morefunc, you can have:


=IF(D23=F23,MCONCAT(G23:G30," "),"?")

Aladin
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top