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:

Please Login or Register  to view this content.

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

there is a logical error on =""

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

Change the ; to ,

**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 !!!!

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

LinkBack

Thread Tools

Rate This Thread

Display

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