One Cell (J3) Answer Is Based On Text In Another Cell (I3)...

J

JonGall

Here's what I need to do:
If cell I3 has the text "NO", then cell J3 will be equal to cell E3
(basically J3 will have the same number as E3).

But If cell I3 has the text "YES", then cell J3 will be E3*L3.

What function will complete the above?

Thanks,

JG
 
K

Kassie

=IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,"")))

--
HTH

Kassie

Replace xxx with hotmail
 
I

Iswar

JonGall said:
Here's what I need to do:
If cell I3 has the text "NO", then cell J3 will be equal to cell E3
(basically J3 will have the same number as E3).

But If cell I3 has the text "YES", then cell J3 will be E3*L3.

What function will complete the above?

Thanks,

JG
Click to expand...

Use the If function if the cell IB contain only 'NO' and 'YES' as shown below.
=IF(I3="NO",E3,(E3*L3))

You need nested function if other data is in I3
 
D

David Biddulph

Do you need the first test, Kassie?
Presumably
=IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,"")))
gives the same result as
=IF(I3="NO",E3,IF(I3="YES",E3*L3,"")) ?
 
Top