If Function

  • Thread starter Thread starter Tilly
  • Start date Start date
T

Tilly

I want to put a sum in the "value if true".

What i want to achieve is that i add 10% to the value of th
neighbouring cell if another cell contains yes and to copy the amoun
form the first cell if the second cell says no. I hope this make
sense. You were all very helpful last time i posted a question so
hope it works. Got to impress the boss!!
 
Greg,

While your formula will return what the OP asked for, if B1 contains
anything but "yes" or "no" it will return FALSE because there is no false
value in the second IF like:

=IF(B1="yes",A1*1.1,IF(B1="no",A1,"Answer Yes or No only please"))

or if it is guarnteed that there will only be "Yes" or "No" in B1 then the
second If is not required:

=IF(B1="yes",A1*1.1,A1)

--
I know it's picky :-)

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
formula help 6
how to sum a column only when an entry exists in a different colum 7
find the correct sum 1
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summing up various Worksheets to one Summary sheet using variables 1
Functions 1

Back
Top