Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
phardy phardy is offline
external usenet poster
 
Posts: 7
Default Formula

yes if e7 is not 80% then nothing will be in the cell. I will try this thanks
for you help!

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7