Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello all,
I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Confusion | Excel Worksheet Functions | |||
Confusion with Names | Excel Discussion (Misc queries) | |||
Confusion..... | Excel Discussion (Misc queries) | |||
Date vs h:mm:ss confusion | New Users to Excel | |||
Chart confusion | Excel Discussion (Misc queries) |