Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed Fortran to VBA
Hi
I nned to convert a Fortran code in VBA: ER_ELIG = .false. ERPOINTS = iage + vsvcb IF ((IGRP.eq.1).and.(iage.ge.55).and.(vsvcb.ge.10)) ER_ELIG = .true. IF ((IGRP.eq.2).and.(iage.ge.50)) ER_ELIG = .true. ERF = 0.00 IF (ER_ELIG) THEN IF (IGRP.eq.1) THEN IF (ERPOINTS.ge.75) then ERF = DIM ( 1. , .04*MIN(4,DIM(62,MAX(55,iage))) + .03*MIN(3,DIM(58,MAX(55,iage))) ) ELSE ERF = DIM ( 1. , .0667*MIN(5,DIM(65,MAX(55,iage))) + .0333*MIN(5,DIM(60,MAX(55,iage))) ) ENDIF IF (vsvcb.ge.25) ERF = 1.000 IF ((iage.ge.62).and.(ERPOINTS.ge.75)) ERF = 1.000 ELSE ERF = DIM ( 1. , .018*MIN(2,DIM(62,MAX(50,iage))) + .036*MIN(5,DIM(60,MAX(50,iage))) + .052*MIN(5,DIM(55,MAX(50,iage))) ) IF (iage.ge.62) ERF = 1.000 ENDIF ENDIF Anyone could help please? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro Fortran to VBA | Excel Programming | |||
Caling fortran from excel | Excel Programming | |||
compaq visual fortran dll | Excel Programming | |||
Calling a Fortran dll from Excel | Excel Programming | |||
Link to fortran | Excel Programming |