software

I am trying to set up a spreadsheet and Need to put in the following function:

If a cell says quot;yesquot; I need to add a dollar amount and if it is quot;noquot; I add
nothing. Could someone please give me some VERY easy to understand
instructions on how to put these formulas in?
--
Your help is very much appreciated!!

Maybe try something like this in C2:
=IF(A2=quot;Yesquot;,B2 10,IF(A2=quot;Noquot;,B2,quot;quot;))

where A2 will house the text: Yes, No, etc ...
and B2 contains a value for which the fixed amount of 10 is to be added

I've presumed that if A2 is either cleared, or contains something other than
quot;Yesquot; or quot;Noquot;, nothing is to appear in C2

Adapt to suit ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Pattyquot; gt; wrote in message
...
gt; I am trying to set up a spreadsheet and Need to put in the following
function:
gt;
gt; If a cell says quot;yesquot; I need to add a dollar amount and if it is quot;noquot; I
add
gt; nothing. Could someone please give me some VERY easy to understand
gt; instructions on how to put these formulas in?
gt; --
gt; Your help is very much appreciated!!