# need cell to read multiple cells and respond to only cells with data

#### jimjim001

##### New Member
So i am trying to create a file for work, and they use google sheets. Usually the formulas are the same anyway.

But I am trying to make cell D2 read cells A2,B2 and C2 and respond if there is something in 1 of those 3 cells..

A2 is reflecting a payment on a monthly cycle from our customers
B2 is fortnightly
and C2 is weekly

There will only ever be data in one of the 3 cells, as customers sign up and choose their frequency of payment as monthly, fortnightly or weekly only.

I want D2 to read the 3 cells, and:
- If a figure is in A2 (monthly), then multiply by 12 and divide by 52 to reflect the rate as a weekly figure.
- If there is a figure in B2 (fortnightly) then simply divide that by 2 to reflect it as a weekly rate.
- If here is a figure in cell C2 (weekly rate) simply repeat that rate in D2.
- If there is nothing in any of the cells, then just be blank.

Image attached for reference.

TIA!

#### Attachments

• Screen Shot 2022-01-10 at 1.11.36 pm.png
26.1 KB · Views: 12

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Try:
Code:
``=IFERROR(A2*CHOOSE(MATCH(TRUE,INDEX(A2:C2<>"",),0),12/52,0.5,1),"")``

Try:
Code:
``=IFERROR(A2*CHOOSE(MATCH(TRUE,INDEX(A2:C2<>"",),0),12/52,0.5,1),"")``
it worked for the monthly, but when I put in the fortnightly or the weekly it just returned a \$0.00

try again:
Code:
``=IFERROR(MAX(A2:C2)*CHOOSE(MATCH(TRUE,INDEX(A2:C2<>"",),0),12/52,0.5,1),"")``

try again:
Code:
``=IFERROR(MAX(A2:C2)*CHOOSE(MATCH(TRUE,INDEX(A2:C2<>"",),0),12/52,0.5,1),"")``
LEGEND!!! that works!

Replies
8
Views
384
Replies
5
Views
490
Replies
0
Views
49
L
Replies
8
Views
707
Legacy 352679
L
Replies
4
Views
338

1,219,807
Messages
6,150,349
Members
450,952
Latest member
Zung

### 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.

### Which adblocker are you using?

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

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