Formula ! need help.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
F3ct said:
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
Click to expand...

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
 
Back
Top