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? |
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? |
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? |
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? |
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? |
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? |
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 |
All times are GMT +1. The time now is 04:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com