How do you create a nested IF function in LibreOffice Calc?

1
 IF(B2>10, "Greater", IF(B2<5, "Less", "Equal")) 
2
IF(B2>10, "Greater"; IF(B2<5, "Less"; "Equal"))
3
IF(B2>10; "Greater"; IF(B2<5; "Less"; "Equal")) 
4
BOTH A & B

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation