ROUND FUNCTION

[EUGENE]

I WANT TO USE THE ROUND FUNCTION TOGETHER WITH ANOTHER
FORMULA EXAMPLE =IF(D8<350,ROUND(D8*0.8),IF(D8<550,ROUND
(D8*0.1),IF(D8<1000,ROUND(D8*0.3),D8*0.4)))
IS THAT POSSIBLE?

 

[Frank Kabel]

Hi
you're nearly there. Try
=IF(D8<350,ROUND(D8*0.8,0),IF(D8<550,ROUND(D8*0.1,0),IF(D8<1000,ROUND(D
8*0.3,0),D8*0.4)))

 

[JE McGimpsey]

One way:

=ROUND(D8*LOOKUP(D8,{0,0.8;350,0.1;550,0.3;1000,0.4}),0)