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