Formula ! need help.

[F3ct]

Hi,

How to express the following formula in Excel format;

Formula 1 , ((A3+B3)/2)(B30/365)

Formula 2 , ((A5+B5)/2)/(B31(365))

I did try but not success.

Thanks

 

[Alex Delamain]

I can see a couple of mistakes

=((A3+B3)/2)(B30/365) Needs an operator (+-*/) between ..2) an
(B30...


=((A5+B5)/2)/(B31(365)) the last term does not work (B31(365)) shoul
be (B31/365) or simila

 

[BenjieLop]

Hi,

How to express the following formula in Excel format;

Formula 1 , ((A3+B3)/2)(B30/365)

Formula 2 , ((A5+B5)/2)/(B31(365))

I did try but not success.

Thanks

Based on your original formulas, the following are the Exce
equivalents:

Formula 1: *=*((A3+B3)/2)***(B30/365)

Formula 2: *=*((A5+B5)/2)/(B31***365)

The *=* signs and * ** converted your original formulas to Excel

 

[F3ct]

It works.
Thanks for yours advice.