Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
hi Amanda,
try =IF(A1="international",A2*16%,IF(A1="european",A2* 20%,0)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
ans=
=IF(A1="international",(A2*0.16),IF(A1="European", (A2*0.2),(A2*0.1))) "Amanda" wrote: I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
Hi Marcelo Thanks very much, Please can you explain the reason for having 2 closing brackets at the end? Is this for the number of arguments? Also what I now need to do is to include another formula: IF A1="INTERNATIONAL" I need to firstly deduct 0.50 from A2, then multiply this amount by 40% then add 0.30 Please can you help me again? Thanks again and regards from Mallorca Amanda "Marcelo" wrote: hi Amanda, try =IF(A1="international",A2*16%,IF(A1="european",A2* 20%,0)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
Hi Len Thanks for your help! Also what I now need to do is to include another formula: IF A1="INTERNATIONAL" I need to firstly deduct 0.50 from A2, then multiply this amount by 40% then add 0.30 Please can you help me again? Thanks again and regards from Mallorca Amanda "len" wrote: ans= =IF(A1="international",(A2*0.16),IF(A1="European", (A2*0.2),(A2*0.1))) "Amanda" wrote: I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
ok
first the 2 brackets at the end are to close all the formula the first one close the second if and the last one close the first if. an if formula works at if(conditional,actions if the condion is true, action if the conditional is false) =IF(A1="international",(((A2-0,50)*,4)+,30)*16%,IF(A1="european",A2*20%,0)) HTH -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: Hi Marcelo Thanks very much, Please can you explain the reason for having 2 closing brackets at the end? Is this for the number of arguments? Also what I now need to do is to include another formula: IF A1="INTERNATIONAL" I need to firstly deduct 0.50 from A2, then multiply this amount by 40% then add 0.30 Please can you help me again? Thanks again and regards from Mallorca Amanda "Marcelo" wrote: hi Amanda, try =IF(A1="international",A2*16%,IF(A1="european",A2* 20%,0)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Amanda" escreveu: I want to say IF A1 = "International" then multiply A2 by 16% and if A1 = "European" then multiply A2 by 20% and if A1 = National then multiply A2 by 10% etc etc etc Please can anybody help? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use if function to different texts
Also what I now need to do is to include another formula: IF A1="INTERNATIONAL" I need to firstly deduct 0.50 from A2, then multiply this amount by 40% then add 0.30 Please can you help me again? Thanks again and regards from Mallorca Amanda "len wrote: from Adelaide Australia ans (1)= =IF(A1="international",(A2*0.16),IF(A1="European", (A2*0.2),(A2*0.1))) The next step is to replace the (a2*0.16) bracket with... (a2-0.5) - keep each formula in its own bracket pair. then add ((a2-0.5)*.4) - Excel will calculate the inner bracket 1st then add the last part finally the formula looks like this...(((A2-0.5)*.4)+0.3) with 3 calculations in one. have fun.. Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Function to next Column | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |