View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
The Rain The Rain is offline
external usenet poster
 
Posts: 19
Default If two Columns have Data enter the Amount Question!

=(H10+I10)*(I100)
Entered in the result cell.
--
Can''''t hear the Rain ?
Then listen to it.


"Killer" wrote:

Example:

H10 = 12
I10 = Blank

Result should be left blank

If

H10 = 12
I10 = 8

Result should be 20

Thanks!