CODEWITHSUNDEEP
if-statementgoogle-sheetssumstring-formattingnumber-formatting
Nick Carfagno
Nick Carfagno

Reputation: 13

Google Sheets use formula results in another formula

Is there any way to get the value from a cell that has a formula in it to be used in another formula?

https://docs.google.com/spreadsheets/d/1jkRAY0REiVHh7jN00Qtsa_OKiGObhHXYRF-qMxyk-r8/edit?usp=sharing

If you check cell D1, it has 0 in it I assume because it cannot get the value from the if() function in the formula for the range.

Thank you!

Upvotes: 1

Views: 1384

Answers (1)

player0
player0

Reputation: 1

try:

=SUMPRODUCT(B1:B50)

or:

=INDEX(SUM(B1:B50*1))

or change your IF to:

=IF(A1 < TODAY(), 2500, 0)

tho B1 should be:

=INDEX(IF(A1:A="",,IF(A1:A < TODAY(), 2500, 0)))

Upvotes: 1

Related Questions