| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function and msgbox
Gentle people
I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
msgbox max(calc1,calc2) & "is the biggest!"
where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
Hi Toopers
I have this error msg "Sub or Function not defined" CC "Toppers" wrote: msgbox max(calc1,calc2) & "is the biggest!" where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
sorry ..... put
msgbox application.max(calc1,calc2) & "is the biggest!" "CC" wrote: Hi Toopers I have this error msg "Sub or Function not defined" CC "Toppers" wrote: msgbox max(calc1,calc2) & "is the biggest!" where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
It's great Toopers
Thanks a lot One more thing ... How can I put name instead of number (eg Material A is the bigest) cc "Toppers" wrote: sorry ..... put msgbox application.max(calc1,calc2) & "is the biggest!" "CC" wrote: Hi Toopers I have this error msg "Sub or Function not defined" CC "Toppers" wrote: msgbox max(calc1,calc2) & "is the biggest!" where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
How do we identify Material A? Is it an a cell?
If Calc1Calc2 then msgbox "Material A is biggest" else msgbox "Material B is biggest" End if Or If Calc1Calc2 then msgbox range("A1") & " is biggest" else msgbox range("A2") & " is biggest" End if A1 contains "Material A", A2 contains "Material B" HTH "CC" wrote: It's great Toopers Thanks a lot One more thing ... How can I put name instead of number (eg Material A is the bigest) cc "Toppers" wrote: sorry ..... put msgbox application.max(calc1,calc2) & "is the biggest!" "CC" wrote: Hi Toopers I have this error msg "Sub or Function not defined" CC "Toppers" wrote: msgbox max(calc1,calc2) & "is the biggest!" where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function and msgbox
Many Thanks Toopers
Look so easy when we Know .... cc "Toppers" wrote: How do we identify Material A? Is it an a cell? If Calc1Calc2 then msgbox "Material A is biggest" else msgbox "Material B is biggest" End if Or If Calc1Calc2 then msgbox range("A1") & " is biggest" else msgbox range("A2") & " is biggest" End if A1 contains "Material A", A2 contains "Material B" HTH "CC" wrote: It's great Toopers Thanks a lot One more thing ... How can I put name instead of number (eg Material A is the bigest) cc "Toppers" wrote: sorry ..... put msgbox application.max(calc1,calc2) & "is the biggest!" "CC" wrote: Hi Toopers I have this error msg "Sub or Function not defined" CC "Toppers" wrote: msgbox max(calc1,calc2) & "is the biggest!" where calc1=material A 2000 litrs * dens 1.3 = 2600 kg calc2=material B 1000 litrs * dens 1.3 = 1300 kg HTH "CC" wrote: Gentle people I'm a beginner... real beginner .. and I have this problem I have two inpuBox with two questions about the amount of materials ( eg. amount of Material A and Amount of Material B) then I made calculations ( eg. material A 2000 litrs * dens 1.3 = 2600 kg and material B 1000 litrs * dens 1.3 = 1300 kg) and my problem is made a Msgbox show the bigest Can you hlp ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does this function NOT return a value? | Excel Discussion (Misc queries) | |||
| Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
| macro to run series of reports to PDF | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
