ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formulae (https://www.excelbanter.com/excel-discussion-misc-queries/79776-formulae.html)

Gerald

formulae
 
Hi All,

I have a field F15 with this formulae = IF(E12="cup", "=E15")

in the field for E15, there is another formulae =a15*b15,

I need the output for E15 in F15, but now I get =E15, what is the operator
to get the output

would appreciate if you could reply

thanks


Bob Phillips

formulae
 
= IF(E12="cup",E15,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gerald" wrote in message
...
Hi All,

I have a field F15 with this formulae = IF(E12="cup", "=E15")

in the field for E15, there is another formulae =a15*b15,

I need the output for E15 in F15, but now I get =E15, what is the operator
to get the output

would appreciate if you could reply

thanks




George

formulae
 
Dear Gerald,

Try
=IF(E12="cup",E15)

Ο χρήστης "Gerald" *γγραψε:

Hi All,

I have a field F15 with this formulae = IF(E12="cup", "=E15")

in the field for E15, there is another formulae =a15*b15,

I need the output for E15 in F15, but now I get =E15, what is the operator
to get the output

would appreciate if you could reply

thanks


Gerald

formulae
 
thanks, cheers

"George" wrote:

Dear Gerald,

Try
=IF(E12="cup",E15)

Ο χρήστης "Gerald" *γγραψε:

Hi All,

I have a field F15 with this formulae = IF(E12="cup", "=E15")

in the field for E15, there is another formulae =a15*b15,

I need the output for E15 in F15, but now I get =E15, what is the operator
to get the output

would appreciate if you could reply

thanks



All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com