formulas
 

I currently have a cell in G4 that is set to take a total from H4 and divide
it in half and then multiply by 1.1. The issue I have a question with is if
that total is less than .74 can it either not populate, revert to zero or
dash? I only want the totals to go to the columns if the total is equal to
or greater than .75. I need totals taken from b - g with the main figure
generating from H

formulas
 

=IF((H4/2)*1.1<0.75,0,(H4/2)*1.1)

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Bell Feed" wrote:

I currently have a cell in G4 that is set to take a total from H4 and divide
it in half and then multiply by 1.1. The issue I have a question with is if
that total is less than .74 can it either not populate, revert to zero or
dash? I only want the totals to go to the columns if the total is equal to
or greater than .75. I need totals taken from b - g with the main figure
generating from H