Excel Macro experts out there?
Closed
dpratt
Posts
1
Registration date
Saturday March 14, 2015
Status
Member
Last seen
March 14, 2015
-
Mar 14, 2015 at 11:40 AM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Mar 15, 2015 at 04:10 PM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Mar 15, 2015 at 04:10 PM
Related:
- Excel Macro experts out there?
- Spell number in excel without macro - Guide
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Macros in excel download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
2 responses
MaxStart
Posts
339
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 15, 2015 at 03:38 PM
Mar 15, 2015 at 03:38 PM
I've created this for you
https://drive.google.com/file/d/0B9oAs-iFHasdMVQ1NElwT3lHeTQ/view?usp=drive_open
this is the basic formula you don't need macros
https://drive.google.com/file/d/0B9oAs-iFHasdMVQ1NElwT3lHeTQ/view?usp=drive_open
this is the basic formula you don't need macros
=IF(A2<=10,85,IF(A2<=25,80,IF(A2<=45,70,IF(AND(A2>45,C2="normal"),65,IF(AND(A2>45,C2="Thin"),70)))))
Mar 15, 2015 at 03:45 PM
This is what I have so far:
Sub Patient_workup()
Dim Value As Integer
Value = Cells(5, 3)
If Value > 45 Then
Cells(28, 3) = 65
End If
End Sub
I do not know how to add the other conditions? Your thoughts?
Mar 15, 2015 at 04:10 PM
it meets all your conditions without the need for macros
I can do a macro but you don't really need it it's just a simple formula