If Function for 2 calculations
 

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.

If Function for 2 calculations
 

in A2 put

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

This should work

--

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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533970

If Function for 2 calculations
 

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.