If Function for 2 calculations

[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.

[Bryan Hessey]

in A2 put

=IF(OFFSET(A2,-1,0)="r",1+2,3+4)

This should work

--

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.

[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.
--
Hope this helps,
MarkN


"Linda Wilson" wrote:

> 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.
>
>