How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

**Altamija** · 02-03-2019, 09:58 AM

Hello Everyone!
Can someone please help me to create a formula to bring value (currency amount) to "D" from column "A"if the cell in Column C is empty, while performing (A2+B2)*C2 in column"D"
Thank you in advance

**Roel Jongman** · 02-03-2019, 10:03 AM

put in D2:

Formula:

=IF(C2="";A2;(A2+B2)*C2)

**Altamija** · 02-03-2019, 10:14 AM

there is a logical error on =""

**torachan** · 02-03-2019, 10:24 AM

It is conflict of regional settings.
Put , (comma's) in place of ; (semi-colons).

**Altamija** · 02-03-2019, 10:29 AM

Yesssss- thank you so much !!!!

**Fluff13** · 02-03-2019, 10:17 AM

Change the ; to ,

How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Re: How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Re: How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Re: How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Re: How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Re: How to bring value form cell A if cell C is empty while doing (A2+B2)*C2

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] vba code to find and paste data to next empty cell, not last empty cell

[SOLVED] Paste formula to the last empty cell based on a non-empty cell on another column

Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location

Bring character specific cell formating from linked cell.

Empty cell Validation on Form

Go to next empty cell then add data using form

If cell is empty, bring down contents of cell above

Bookmarks

Bookmarks

Posting Permissions