Change Value

  • Thread starter Thread starter Salza
  • Start date Start date
S

Salza

Hi all,

I have this formula in a cell (say, in BG7) in my exam worksheet.

=IF(BE7="S",100,"0")

I will get value 100 if the cell in BE7 is S. And 0 value if the cell in BE7
is not marked S.
That works fine.


What is the correct formula if I want to change the value 100 in the
formula above so that the value is equal to a value in one of the cell of
the same row(say, in cell BE9).

I mean if cell BE9 has a value 20, then if the formula above is true, 20
appears in BG7.

Please help. Thanks.
 
Hi Salza!

It looks like all you need is:

=IF(BE7="S",BE9,"0")

But I may have misinterpreted your question.
Do you really want a false value of zero as text?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top