IF formula

D

Dalyb2

New Member
Joined
May 10, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Mobile
To be specific:

I need cell B8 to show the value of cell D100 only if cell B3 is equal to a special value (17), OR show value of cell K100 if equal to a different specific value (29)
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

C
  • Question Question
Formula returning #VALUE! help
2
Replies
10
Views
170
Peter_SSs
Peter_SSs
K
  • Question Question
IF formula help please
Replies
5
Views
65
Fluff
Fluff
achonikolov
  • Solved
Copy and paste range in different sheet
2
Replies
10
Views
192
achonikolov
achonikolov
D
  • Question Question
Vlookup
Replies
5
Views
266
Joe4
Joe4
S
  • Solved
Macro adding Sum if value is True
Replies
1
Views
100
sstarnes
S

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top