Count no of Poles as per setting

[Juniad]

Hi, i have one sheet where i want to count the no of poles.. i want to fix the camera's on pole so no of camera's i will set in setting cell so based on setting cell i want to count the no of poles.
Exp:
in setting cell if i set 2 cameras per pole then whatever i enter in camera cell pole should be calculated automatically.

Attachment is available for further detail.

 

[AliGW]

Maybe change ROUND to ROUNDUP:

=IFERROR(ROUNDUP(IF(F4=2,G4/2,G4/F4+IF(MOD(G4,F4)>1,0,MOD(G4,F4))),0),"")

 

[Juniad]

Maybe change ROUND to ROUNDUP:

=IFERROR(ROUNDUP(IF(F4=2,G4/2,G4/F4+IF(MOD(G4,F4)>1,0,MOD(G4,F4))),0),"")

Not working properly.. if am changing the no of camera's then am not getting the correct answer.

 

[Khalid NGO]

Hi Junaid,

If you can include your all inputs with expected results, it will be easy to share targeted answers.

You can also use Ceiling function:
=CEILING(G4/F4,1)

Regards,

 

[Peter Bartholomew]

Rounding up, the number of cameras you must be able to mount is
= CEILING(cameras, setting)
This requires
= CEILING(cameras, setting) / setting
poles. If you also wish to avoid showing errors when 'setting' is not input
= IF( setting, CEILING(cameras, setting) / setting, "" )

 

[Juniad]

Thanks, It works..