Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF function with AND/OR
Hi
I have successfully used the IF function on my worksheet so that if two conditions are met it will do one calculation or another However I'd like to know if its possible to get it to work with three conditions e.g if a1="y" AND b1="y" then f1*5% otherwise f1*10% but if a1<"y" then just ignore the calculation and enter a zero or a blank space. I've got as far as nesting the first logical part which works e.g. =IF(AND(A1="y",B1="y"),F1*5%,F1*10%) But it falls over if A1 is anything other than "y". How can I get it to do the first if/then but ignore them both if A1 does not = "y"? I hope this is clear and there isn't too much repetition. Thanks very much for your time and assistance Ian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF function with AND/OR
One way:
=IF(A1<"Y",0,IF(AND(A1="y",B1="y"),F1*5%,F1*10%)) Ian R wrote: Hi I have successfully used the IF function on my worksheet so that if two conditions are met it will do one calculation or another However I'd like to know if its possible to get it to work with three conditions e.g if a1="y" AND b1="y" then f1*5% otherwise f1*10% but if a1<"y" then just ignore the calculation and enter a zero or a blank space. I've got as far as nesting the first logical part which works e.g. =IF(AND(A1="y",B1="y"),F1*5%,F1*10%) But it falls over if A1 is anything other than "y". How can I get it to do the first if/then but ignore them both if A1 does not = "y"? I hope this is clear and there isn't too much repetition. Thanks very much for your time and assistance Ian -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF function with AND/OR
=IF(A1<"Y",0,IF(AND(A1="Y",B1="Y"),0.05,0.1)*F1)
"Ian R" wrote: Hi I have successfully used the IF function on my worksheet so that if two conditions are met it will do one calculation or another However I'd like to know if its possible to get it to work with three conditions e.g if a1="y" AND b1="y" then f1*5% otherwise f1*10% but if a1<"y" then just ignore the calculation and enter a zero or a blank space. I've got as far as nesting the first logical part which works e.g. =IF(AND(A1="y",B1="y"),F1*5%,F1*10%) But it falls over if A1 is anything other than "y". How can I get it to do the first if/then but ignore them both if A1 does not = "y"? I hope this is clear and there isn't too much repetition. Thanks very much for your time and assistance Ian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF function with AND/OR
"Ian R" wrote in message ... Hi I have successfully used the IF function on my worksheet so that if two conditions are met it will do one calculation or another However I'd like to know if its possible to get it to work with three conditions e.g if a1="y" AND b1="y" then f1*5% otherwise f1*10% but if a1<"y" then just ignore the calculation and enter a zero or a blank space. I've got as far as nesting the first logical part which works e.g. =IF(AND(A1="y",B1="y"),F1*5%,F1*10%) But it falls over if A1 is anything other than "y". How can I get it to do the first if/then but ignore them both if A1 does not = "y"? I hope this is clear and there isn't too much repetition. Thanks very much for your time and assistance Ian Dave & Mama Thanks guys - worked a treat! I've been pulling my hair out on this one for ages. I humbly bow in my appreciation to you Guru's! Ian I^) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using IF function with AND/OR
=IF(A1<"y",0,IF(B1="y",F1*5%,F1*10%))
[You don't need the AND(A1="y",B1="y"), because you don't get to the second test unless A1="y".] -- David Biddulph "Ian R" wrote in message ... Hi I have successfully used the IF function on my worksheet so that if two conditions are met it will do one calculation or another However I'd like to know if its possible to get it to work with three conditions e.g if a1="y" AND b1="y" then f1*5% otherwise f1*10% but if a1<"y" then just ignore the calculation and enter a zero or a blank space. I've got as far as nesting the first logical part which works e.g. =IF(AND(A1="y",B1="y"),F1*5%,F1*10%) But it falls over if A1 is anything other than "y". How can I get it to do the first if/then but ignore them both if A1 does not = "y"? I hope this is clear and there isn't too much repetition. Thanks very much for your time and assistance Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of functions contained in the add-ins, esp. Analysis Toolpak | Excel Worksheet Functions | |||
Fill Function to next Column | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |