Showing two results in same cell

T

Tennisguuy

Well-known Member
Joined
Oct 17, 2007
Messages
564
Office Version
  1. 2016
Platform
  1. Windows
I'm not sure it is possible but can excel display to results in one formula. For example I have the following formula:

IF($K$2="","",IF(D12=0,"",IF(AND(Z17=0.01,W17>=0.6),"Policy",IF(AND(Z17=0.02,W17>=0.8),"Policy",IF(AND(Z17=0.05,W17>=1),"Policy","Wind")))))

Basically the formula will return either the word "policy" or "wind" which is want I want it do but was also wondering if along with displaying either "policy" or "wind" if it could also show what the value is in cell W17 which is would a percentage. Something like this Wind-90% if the value in W17 was 90%.

The formula is in cell is in cell F12 and I know I can just put a formula right next to it in cell G12 to display the value in cell W17 but I already have another formula for something else in the cell.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Like this?

IF($K$2="","",IF(D12=0,"",IF(AND(Z17=0.01,W17>=0.6),"Policy - "& W17,IF(AND(Z17=0.02,W17>=0.8),"Policy - "& W17,IF(AND(Z17=0.05,W17>=1),"Policy - "& W17,"Wind - "& W17)))))
 
Upvote 0
Just use this modified version of your formula where I show the part I added in red...

=IF($K$2="","",IF(D12=0,"",IF(AND(Z17=0.01,W17>=0.6),"Policy",IF(AND(Z17=0.02,W17>=0.8),"Policy",IF(AND(Z17=0.05,W17>=1),"Policy","Wind")))&" "&W17))
 
Upvote 0
That worked but have one other question. It returns the value in cell W17 but I have it formatted for percentage and when it return the value it uses a whole number. For example if the value in W17 is 110% it shows 1.10. Is there a way I can have it show as a percentage.
 
Upvote 0
I used Rick's method because I didn't have to change the formula much. When I tried the above I got an error message I just replace &" "&W17 to &" W17*100&"%". It said this formula contained a error message.
 
Upvote 0
Tennisguuy said:
I used Rick's method because I didn't have to change the formula much. When I tried the above I got an error message I just replace &" "&W17 to &" W17*100&"%". It said this formula contained a error message.
Click to expand...
Either of these should work...


=IF($K$2="","",IF(D12=0,"",IF(AND(Z17=0.01,W17>=0.6),"Policy",IF(AND(Z17=0.02,W17>=0.8),"Policy",IF(AND(Z17=0.05,W17>=1),"Policy","Wind")))&" "&W17*100&"%"))


=IF($K$2="","",IF(D12=0,"",IF(AND(Z17=0.01,W17>=0.6),"Policy",IF(AND(Z17=0.02,W17>=0.8),"Policy",IF(AND(Z17=0.05,W17>=1),"Policy","Wind")))&" "&TEXT(W17,"0%")))
 
Upvote 0
Thanks Rick that work. Thanks again both. I really appreciate your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Trying to create a results sheet using two data ranges
Replies
0
Views
169
Doot
D
B
  • Solved
Display result of formula which is millions as nn.n without losing original value of cell and no 'M' in the result cell either.
Replies
3
Views
350
awoohaw
awoohaw
R
  • Solved
Display alternate text based on value in another cell
Replies
3
Views
137
etaf
etaf
K
  • Question
AVERAGEIFS / SUMIF with multiple criteria
Replies
3
Views
830
arthurbr
arthurbr
M
  • Solved
Obtaining data from a cell reference contained within a cell.
Replies
3
Views
130
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,059
Messages
6,122,917
Members
449,093
Latest member
dbomb1414

Share this page

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