Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"IF..THEN.."formulas
Can you do "IF...THEN..."formulas in EXCEL and How? Thanks
Mari |
#2
|
|||
|
|||
Hello there,
There is an IF function in Excel. =IF(Condition,True,False) For Example: If a customers' balance is in cell A1 then, =IF(A10,"Credit","Debit") You can also add nested IFs, eg. If a pupils score is in A1 then, =IF(A180,"Excellent",IF(A150,"Pass","Fail")) You keep adding Conditions and Trues until the end when you add the False. You can have upto 7 nested IFs. Remember to start with the highest first as Excel looks at the conditions in order. I.E. if the nested IF above was created like: =IF(A150,"Pass",IF(A180,"Excellent","Fail")) Anyone with over 50 will get Pass even if they have over 80 as a condition has already been met. I hope this helps Judith -----Original Message----- Can you do "IF...THEN..."formulas in EXCEL and How? Thanks Mari . |
#3
|
|||
|
|||
Hi
=IF(Condition,TrueAnswer,FalseAnswer) An example: =IF(OR(B2=0,B2="",A2=""),"",A2/B2) -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "Mari P" <Mari wrote in message ... Can you do "IF...THEN..."formulas in EXCEL and How? Thanks Mari |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |