Skip to main content
added 8 characters in body; edited tags
Source Link

My googleGoogle sheet formula isn't working as intended.

In order to calculate the ROI of an event imI'm making I use different stats and make a big calculation of points atin the ROI collumn [![Presentation of the collumn blank][1]][1]column

Presentation of the collumn blank

The formula I'm currently using: =G9 + (H9 * 2) + (I9 * 2) + (J9 * -4) + (K9 / 15) + (L9 * 0.5)=G9 + (H9 * 2) + (I9 * 2) + (J9 * -4) + (K9 / 15) + (L9 * 0.5)

But the ROI cases stay in Error and tell me there is an error in the formula and doesn't give any detail.

I've already checked every entrance and they are correct [![error][2]][2]error

Can someone help me solved this ? [1]: https://i.sstatic.net/JtuIwN2C.png [2]: https://i.sstatic.net/QsXuptJn.png

My google sheet formula isn't working as intended.

In order to calculate the ROI of an event im making I use different stats and make a big calculation of points at the ROI collumn [![Presentation of the collumn blank][1]][1]

The formula I'm currently using: =G9 + (H9 * 2) + (I9 * 2) + (J9 * -4) + (K9 / 15) + (L9 * 0.5)

But the ROI cases stay in Error and tell me there is an error in the formula and doesn't give any detail.

I've already checked every entrance and they are correct [![error][2]][2]

Can someone help me solved this ? [1]: https://i.sstatic.net/JtuIwN2C.png [2]: https://i.sstatic.net/QsXuptJn.png

My Google sheet formula isn't working as intended.

In order to calculate the ROI of an event I'm making I use different stats and make a big calculation of points in the ROI column

Presentation of the collumn blank

The formula I'm currently using: =G9 + (H9 * 2) + (I9 * 2) + (J9 * -4) + (K9 / 15) + (L9 * 0.5)

But the ROI cases stay in Error and tell me there is an error in the formula and doesn't give any detail.

I've already checked every entrance and they are correct error

Can someone help me solved this ?

Post Migrated Here from superuser.com (revisions)
Source Link
Maslie
Maslie

Google sheet ROI formula not working

My google sheet formula isn't working as intended.

In order to calculate the ROI of an event im making I use different stats and make a big calculation of points at the ROI collumn [![Presentation of the collumn blank][1]][1]

The formula I'm currently using: =G9 + (H9 * 2) + (I9 * 2) + (J9 * -4) + (K9 / 15) + (L9 * 0.5)

But the ROI cases stay in Error and tell me there is an error in the formula and doesn't give any detail.

I've already checked every entrance and they are correct [![error][2]][2]

Can someone help me solved this ? [1]: https://i.sstatic.net/JtuIwN2C.png [2]: https://i.sstatic.net/QsXuptJn.png