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