Excel program - Microsoft Community

how write excel program formula below calculate , display real , imaginary part values in same cell

n = (1+r^0.5)/(1-r^0.5)

when r = -0.0427 example.

...write excel program ...calculate , display...in same cell

it isn't clear me if asking vba help, , since can done more (if not familiar vba) using regular formulas, i'll provide approach here unless post again asking how started vba.

generally, can calculate want in formulas , push cells, , if want show multiple values, have turn text. thing have watch out formatting of numeric results.

for example, let's wanted show 2 percentages, equivalent of

part a: % of 100 people asked said ice cream, and

part b: % of people ice cream, happen chocolate ice cream best.

a=84%  (e.g. 84/100)

b=49%  (e.g. 41/84)

[edit: i'd suggest plugging each of these cell, can see result of each calculation below]

in cell, concatenate two:

c1= 84/100  & "   " & 41/84

but leaves 2 issues. first, neither number expressed percent, , second, b value long decimal value. so, wrap both in text conversion

c1= =text(84/100,"00%") & "    " & text(41/84,"00%")

and can add words explain values seeing

c1=text(84/100,"00%") & " of people ice cream, and " & text(41/84,"00%") & " of chocolate best"

what show in cell is:

84% of people ice cream, , 49% of chocolate best

Office / Excel / Microsoft Office Programming / Office 2007