Calculating a value base on senarios

NZAS

Board Regular
Joined
Oct 18, 2012
Messages
104
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi

I need some help for a formula to do some caclculations.
Cell A1 has a value xxx at times
Cell A2 has a value xxx at times
There are time when only one of these cell could have a value in them. The formula I am looking for is
If cell A1 or A2 has a value multply value in cell multply by 1 ie a value in either cell not both

If cell A2 has value and cell A1 has value the multply cell C1 by 2 and add to A1 or A2 value

These are the likly senarios

Senarios
cell A12310
cell A21010
Cell C1171717
Here cell C1 is multiplied 341717
Add cell c1 to A1 and or A2 depending on if values in cell
A4 cell672727

<tbody>
</tbody><colgroup><col><col span="3"></colgroup>


Answer A4 67 27 27 Need the formula in cell A4

Cheers
NZAS
 
Last edited:

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

NZAS

Board Regular
Joined
Oct 18, 2012
Messages
104
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Thankyou M
That has work great for me
Cheers
NZAS
 

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,297
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top