Calculation on a non-blank cell in a horizontal range

JSchell

New Member
Joined
Jan 4, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi,

Been knocking my head against this for too long. I have this spreadsheet where I am trying to add a formula in column D to search for a value in a row of cells from F-Q (columns don't matter).

So essentially, I want the formula to find the value in the row (there will only be one value or blank) and then do a calculation on that value.

For example: Search row 5 to see that there is a value in H5 then do a calculation on the value of $1600.00.

I figured it was an IF statement coupled with ISBLANK, but that doesn't seem to work as everything I have seen looks for a specific value as opposed to the value that is in the cell that isn't blank.

  • The values will all be numeric.
  • There will only be one value per row.
  • The value could be virtually any amount.

Thanks in advance for the help!

Screenshot 2024-01-04 163816.png
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Are there formulae in those cells that return "" or are they totally empty?
 
Upvote 0
Hi,

They are totally empty and the dollar values that are there are inputted manually.
 
Upvote 0

Forum statistics

Threads
1,215,068
Messages
6,122,950
Members
449,095
Latest member
nmaske

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