Need formula to sequentially look in three columns and return calculation if column is populated.

		Microsoft Office Forums > Microsoft Excel > Excel
Need formula to sequentially look in three columns and return calculation if column is populated.

FAQ

Thread Tools

Display Modes

09-03-2024, 07:25 AM

wsnow

Windows 11 Need formula to sequentially look in three columns and return calculation if column is populated.

Office 2021

Novice

Join Date: Sep 2023

Posts: 24

Turns out I had unneeded ) after each instance of .88, but needed one additional one at the very end. A co-worker spotted the error.
=IF(ISNUMBER([@[12-Month Lock-in Amount]]), [@[12-Month Lock-in Amount]]*0.88, IF(ISNUMBER([@[6-Month Estimate]]),[@[6-Month Estimate]]*0.88, IF(ISNUMBER([@[30-Day Estimate]]),[@[30-Day Estimate]]*0.88, "")))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting populated cells (range) in one column, that fall between 2 (diff) values in another column	SnakeDoctor	Excel	17	08-02-2024 08:39 AM
Whats the correct formula to point to the last populated cell in a column?	oscarlimerick	Excel	4	03-09-2021 08:00 AM
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values	eduams	Mail Merge	1	09-26-2016 07:02 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 AM.