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

If a cell says "yes" I need to add a dollar amount and if it is "no" 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="Yes",B2+10,IF(A2="No",B2,""))

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
"Yes" or "No", nothing is to appear in C2

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Patty" wrote in message
...
I am trying to set up a spreadsheet and Need to put in the following
function:

If a cell says "yes" I need to add a dollar amount and if it is "no" 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!!