| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set a cell value based on "OR" function?
Of course the 15 should have been 5 in both cases
-- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Hi Ron, | | =IF(A1="M",B1+10,B1+15) | | or, to check for something not F or M: | | =IF(A1="m",B1+10,IF(A1="F",B1+15,"ERROR")) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Ronnie" wrote in message ... ||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
