| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set a cell value based on "OR" function?
I need to caluclate the value of C1 depending on sexe (M or F)
A1 = M or F B1 = 40 If A1=M then C1=B1+10, Or IF A1=F then C1=B1+5 How do i get this in one formula? Each seperate formula for M and F works fine, however when combining both the system returns TRUE in C1 i.s.o. a calucalated value Thanks in advance, Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
Threaded Mode
