| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set a cell value based on "OR" function?
=IF(A1="M",B1+10,B1+5)
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Ronnie" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set a cell value based on "OR" function?
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 |
|
#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 | | |
| Reply |
| 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 | |||
Linear Mode
