If Formula to calculate cell with value

[willsnicholas]

I am trying to create a formula that will create a result for a cell if a range of three cells has a value:

IN K6------->

IF D6 contains value multiply G6 by 15
IF E6 contains value multiply G6 by 15
IF F6 contains value multiply G6 by 10

Each row (6-xxxx) will have a value in ONLY one cell

HELP!?????????

 

[willsnicholas]

I would need two more formulas:

The first:

I value/Text in L6 add 10 in N6, if value in M6 add 30 to N6, if nothing add 0, again this would be one or the other

The other function is slightly more complicated,

it would be CHANGE in value from B6 to C6 and so on, would add 10 to P7. Meaning if cell B6 had 5, but then B7 had 10, P7 would add a 10. Then if B7-B13 stay at 10, there would be no change so a zero would be added to P8 and so on. Does that make sense?

You can explain it with examples.
You can upload images to dropbox

You could upload a copy of your file or img file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[willsnicholas]

Kweaver,

THANK YOU!!!

I would need three more formulas:

The first:

If there is value/text in M6 add 10 in O6, if value in N6 add 30 to O6, if nothing add 0 in O6, again this would be one or the other

--------------------------------------------------------------------------

The other functions are slightly more complicated,

it would be CHANGE in value from B6 to C6 and so on, would add 10 to P7. Meaning if cell B6 had 5, but then B7 had 10, P7 would add a 10. Then if B7-B13 stay at 10, there would be no change so a zero would be added to P8 and so on. Does that make sense?


-----------------------------------------------------------------

The Last would be a calculation that would rely on three factors:

Value/text in column D-F6
The actual number in column J
Divided by a number that is reliant on the column with a value/text in D-F6

For Example

IN COLUMN L6
IF there is a value/text in column D6, Divide number in J6 By 11
IF there is a value/text in cloumn E6, Divide number in J6 by 11
If there is a value/text in column F6, Divide number by 6

 

[willsnicholas]

Kweaver,

THANK YOU!!!

I would need three more formulas:

The first:

If there is value/text in M6 add 10 in O6, if value in N6 add 30 to O6, if nothing add 0 in O6, again this would be one or the other

--------------------------------------------------------------------------

The other functions are slightly more complicated,

it would be CHANGE in value from B6 to C6 and so on, would add 10 to P7. Meaning if cell B6 had 5, but then B7 had 10, P7 would add a 10. Then if B7-B13 stay at 10, there would be no change so a zero would be added to P8 and so on. Does that make sense?


-----------------------------------------------------------------

The Last would be a calculation that would rely on three factors:

Value/text in column D-F6
The actual number in column J
Divided by a number that is reliant on the column with a value/text in D-F6

For Example

IN COLUMN L6
IF there is a value/text in column D6, Divide number in J6 By 11
IF there is a value/text in cloumn E6, Divide number in J6 by 11
If there is a value/text in column F6, Divide number by 6

You didn't say what might be in D6, E6 or F6 (numbers, text, blank), so this just checks to see if anything is there. What happens if all three conditions fail?

=IF(OR(NOT(ISBLANK(D6)),NOT(ISBLANK(E6))),G6*15,IF(NOT(ISBLANK(F6)),G6*10,"?"))

sandy666: doesn't yours assume the values are numbers and you always multiply by 15 whereas sometimes you multiply by 10?