If statement on range

jezza667

New Member
Joined
Feb 25, 2022
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
Hi, I am trying to work out how to write an IF statement/ formula that looks at 2 cells in Sheet A of my workbook and displays the value of the cell that has text in it (one of the 2 cells will always be 0) in Sheet B of my workbook.

I'm struggling to work out how to do it... any advice please? TIA
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Another option
Excel Formula:
=IF(ISTEXT(Sheet1!A1),Sheet1!A1,Sheet1!B1)
 
Upvote 0
Neither of those work I'm afraid so I think I am probably asking the wrong question. Further context to my ask is below:

I'm creating a form in an Excel workbook for logo design requests. In the form, users will either use the form to :
a) raise a new request OR
b) manage an existing request

Both of these 'journeys' have common fields such as name, date of request, department etc.

After a user has gone through one of these two 'journeys' (they will never go through both in the same form), they then have to go through to another sheet in the same workbook (in the same form) to request their logo be uploaded to a website (lets call this Upload Journey). This 'journey' shares some similar fields such as name, date of request, department, etc. Regardless of whether the request is new or existing, the user will always end up in the same Upload Journey sheet.

When the user opens the Upload Journey, I would like those common fields (name, date of request, etc) to be pre-populated based on which previous 'journey' the user took in the form (i.e. raise a new request or manage an existing request).
 
Upvote 0
In what way didn't the two formula work?
 
Upvote 0
Excel didn't update the destination cell when I switched between entering data in the new and existing journeys.

both statements suggested above kept returning '0'
 
Upvote 0
Do you have calculation set to automatic?
Also what did you enter in A1 or B1?
 
Upvote 0

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

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