CODEWITHSUNDEEP
excelexcel-formulaformulas
uxkidd
uxkidd

Reputation: 69

Google Sheets ROUNDDOWN formula doesn't work in Excel?

This is a formula I'm using in a Gantt/time-line chart to drive different values to a cell:

=if(AND((K$3>=$G8),(K$3<=$H8)),if((ROUNDDOWN($J8*$I8)<=(K$3-$G8)), "X", "Y"),"")

It works fine in Google Sheets, but when pasted into Excel, it throws an error that says "Not enough arguments were entered for this function."

Is there an easy way to fix this?

Upvotes: 1

Views: 336

Answers (2)

uxkidd
uxkidd

Reputation: 69

I was able to just add a comma after J8*I8, and that seemed to solve the issue. Excel required a digit there for some reason.

Upvotes: 0

Kresimir L.
Kresimir L.

Reputation: 2441

your roundown part is missing an argument. try this =IF(AND((K$3>=$G8),(K$3<=$H8)),IF((ROUNDDOWN($J8*$I8,0)<=(K$3-$G8)),"X","Y"),"")

Upvotes: 3

Related Questions