If function

N

Neil Greenough

In cells in Column A, I have a dropdown box listing 'yes' and 'no' for users
to choose from.

In Column B and C are two values

In column D, I would like the total of Cells B & C (ie =B1+C1) only if 'no'
is selected from column A. If 'yes' is selected, I would like B and C added
together and then minus 30. All cells are formated to time (hh:mm) and so it
would be half an hour I would like minused if 'yes' is selected.

Any ideas?

Thanks
 

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

Data Validation and drop-down list using IF, AND and what else? 8
Lookup 14
Copy cells to different sheet if value found 1
Table cross-check 0
String Search 3
Find Mismatched Data 5
checking for positive or negative numbers 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top