If Function for 2 calculations

L

Linda Wilson

I want the cell to do a calculation based on the contents of the preceeding
cell. If the preceeding cell contains R, I want it to complete one
calculation, but if the cell contains something different, I want it to
complete a different calculation.

Can anyone provide a suggestion for this?

Thank you.
 
M

MarkN

Hi,

Try using an IF function, =IF(A1="R",A2*20%,A2*30%). In the function, A1="R"
is a logical test that evaluates to TRUE or FALSE. If A1="R", the logical
test evaluates to TRUE, and the calculation A2*20% will be returned to the
active cell. If A1 does not equal "R", the logical test evaluates to FALSE,
and the calculation A2*30% will be returned to the active cell.
 
Top